About SQL Compare
Published 26 June 2013
With SQL Compare, you can compare and deploy the structure of two Microsoft SQL Server databases.
This is useful, for example, in a development environment when changes made to a local database need to be transferred to a live database on a remote server. Traditionally, this meant spending hours scrutinizing the database structure and hand-generating migration scripts. SQL Compare automates this process for you.
You can use SQL Compare to compare and syncronize SQL Server 2008, SQL Server 2005 and SQL Server 2000 databases.
Quick start guide
- Choose the data sources to compare
- View the comparison results
- Set up the synchronization
- Create the synchronization script
Learn more about SQL Compare by following these detailed examples: