 |
SQL Compare enables you to compare and synchronize 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 synchronize SQL Server 2000 and SQL Server 2005 databases.
To see an overview of how you use SQL Compare, and optionally try it out for yourself, see Comparing and Synchronizing Two Databases and Using SQL Scripts as a Data Source.
Note that you can follow the second worked example only if you are using SQL Compare Professional edition.
SQL Changeset is provided with SQL Compare Professional Edition for integration with your source control system. For more information, see the SQL Changeset help.
For information on what's new in this version, see http://www.red-gate.com/support/versions/index.htm.
© Red Gate Software Ltd 2007. All Rights Reserved.