The Database Design Resource Center

Compare Databases
(SQL Server)

Compare databases: SQL Delta is a database tool that offers comprehensive, high-speed integrated data and structure comparison plus synchronization for SQL Server database systems.

When you have different database versions, you need to manage changes between them. In order to compare them, a tool like SQLDelta is invaluable. Features include:

DBxtra is a stand-alone, ad-hoc query and database reporting tool which connects to unlimited databases, l ike Access, MS SQL Server, MySQL, Oracle9i, Paradox, FoxPro, DBF, Excel and text.

Projects

A project manager feature is included to allow the saving of connection and option settings. The project manager significantly reduces the number of keystrokes or mouse clicks required to select and compare databases. The tables that have been selected for data compare are also saved as part of the project, streamlining the data compare process.

Connection Manager

SQL Delta is capable of storing common connection details into a connection manager to simplify and expedite the database selection process. The connection manager allows the user to choose a server and database from a list of friendly connection names. Even the passwords are saved with the connection details, in an encrypted format. Of course it still remains possible to "manually" connect to a database server.

Snapshots and Offline Comparisons

The introduction of off-line mode enables users to take a snap shot and export the database structure to a file and then re-load the structure and later compare databases without the need to access their database server.

Database Diagram Copying

SQL Delta has the ability for users to move database diagrams between databases and will detect any diagrammatic changes and enable synchronization of the diagrams.

Full Text Catalogues and Support for Case Sensitive Structure Comparisons

The structure compare process include support for full text catalogues, case sensitive structures and better support for the ignore index and constraint names options.

SQLDelta offers a 15-day risk-free trial: Download here:

Single-user license download
5 concurrent users license download
Full site license download

Return from Compare databases to Database Software products



Database Design FORUM
Site Build It!


What visitors say...

"I just stumbled across your site looking for some normalization theory and I have to say it is fantastic.

I have been in the database field for 10+ years and I have never before come across such a useful site.

Thank you for taking the time to put this site together."

Mike, USA

Read more Testimonials

Free eBook

Subscribe to my newsletter and get my ebook on Entity Relationship Modeling Principles as a free gift:


Workshop

On rare occasions, I may perform a Database Design Workshop . Unfortunately, I am currently unable to, but maybe later...

Influence me

Influence the content on this site: I want to know what database information you need the most: Participate in my Database Design Content investigation. I would appreciate it if you took the time...

Database Normalization eBook:


Database Normalization eBook


XML RSS
Add to My Yahoo!
Add to My MSN
Add to Google


Site Build It!

ADD TO YOUR SOCIAL BOOKMARKS: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Copyright © 2004-2008 www.databasedesign-resource.com / Alf A. Pedersen
All rights reserved.
All information contained on this website is for informational purposes only.
*Disclaimer: www.databasedesign-resource.com does not warrant any company, product, service or any content contained herein.

Return to top

Copyright acknowledgement note:

The name Oracle is a trademark of Oracle Corporation.
The names MS Access/MS SQL Server are trademarks of Microsoft Corporation.
Any other names used on this website may be trademarks of their respective owners, which I fully respect.