Software Documentation.Info Logo

 
Subscribe to our blog and be notified about new business software resources
  home | technical writing | business software | software documentation tools | service business software | software testing | contact

Other Software Links

Home > Useful Software Products > Database Software > Database Snapshot Software for SQL Server > SQL Compare for SQL Server

SQL Compare for SQL Server

SQL Compare from Red Gate Software Limited is the industry standard solution for comparing schema from different copies of a database. Comparing database schemes is an essential task to perform before database changes are deployed from a test to a live environment. If an application attempts to run SQL scripts against a database with an outdated schema then this can lead to all kinds of problems, many of which can be difficult to track down.

SQL Compare can automatically create schema change scripts in order to script the changes found between two copies of a database. This makes it straightforward to enact database structural changes in a change control system. Comprehensive reporting options also allow developers and DBA's to check that the database structure hasn't been changed between test and live systems.

SQL Compare can compare live databases, as well as databases that only exist as SQL Server backups, or as schema backups.

SQL Compare has an easy to use graphical user interface. It is also programmable from the command line so that database comparison jobs can be automated and scheduled to run at regular intervals.

For comparing database schema on Oracle databases, a similar product to SQL Compare is available called Schema Compare for Oracle.

SQL Compare
Software for comparing SQL Server databases

Related content: database, sql server, schema


© 2007 - 2012 Winnersh Triangle Web Solutions Limited.
Registered company number: 4493816.

Page created Thursday, June 03, 2010. Last modified Thursday, June 03, 2010.
About This Website | | Site Map | Privacy Policy | Add Your Site