A Database Comparison Tool by Red-Gate Software

SQL Compare is the industry standard tool for comparing and synchronizing SQL Server database structures and is used by over 150,000,000 DBAs, developers and testers.

SQL Compare:

- Compares SQL Server database structures
- Quickly pinpoints the differences in the databases
- Quickly generates the synchronization scripts
- Allows you to save the scripts
- Generates reports in either Word or HTML
- Warns you about anything you should be aware of before running a synchronization script
- Synchronizes database structures

SQL Compare is for use in a development environment when changes made to a local database need to be pushed to a test or live database, for example. Traditionally, this meant spending hours trawling through database schemas, hand-generating migration scripts. SQL Compare will compare and synchronize all database objects, including, but not limited to, tables, stored procedures, views and user-defined functions. It does this fiddly and tedious job properly by, for example, properly taking into account dependencies and referential integrity, and the SQL scripts are of a very high quality.

Testimonials:
“…It's amazing how fast it now registers huge databases...”, Sitekit Solutions; “…Performance is awesome…”, Penn National Insurance; “…database comparison now takes less than 10 minutes.", London Bridge Group.