Use the Red Gate SQL Compare Database Synchronization tool for the structure comparison, synchronization of SQL Server two databases

When the beta version of the project is synchronized (deployed) to the official version, the structure of the two databases compared with the synchronization, if the database is not modified when modifying those tables, it is difficult to synchronize two of databases

Redgate SQL Compare usage Brief description:

1. Compare and synchronize all objects in the database including stored procedures, relationships, tables, views, and user-defined functions

2. Report all discrepancies

3. Generate a migration script that runs directly on the target database

Red Gate SQL Compare official website: http://www.red-gate.com/products/sql-development/sql-compare/index-b

Below, see red Gate SQL Compare Synchronous usage:

1.

2.

3.

4.

5.

6.

7.

Use the Red Gate SQL Compare Database Synchronization tool for the structure comparison, synchronization of SQL Server two databases