Implement schema synchronization between SQL Server databases

When a project is under development, the database should be divided into at least two environments: The Development (TEST) database and the formal database. Some projects are even divided into three databases, such as Dev, Stg, and PRD ), how to synchronize Schemas between several databases is a big challenge.

The replication function of SQL Server 2005 can synchronize data between databases, but it is difficult to synchronize DDL or schema.

Toad for SQL Server is a recommended tool. It provides this function. schema compare can basically compare different objects in two databases, such as table, view, SP, trigger, PK, and FK. After the comparison is completed, a SQL statement comparison table will appear, allowing the user to decide on how to synchronize, and the two databases can be compared and synchronized.

 

For more information, see toadforsql. pdf.

Click to download the software: toadforsql