How to compare and synchronize the schemas? - SQL Server Comparison Expert
Home > News > How to compare and synchronize the schemas?

How to compare and synchronize the schemas?

To compare and synchronize the schemas of two databases, you can use Schema Comarer or Database Comparer. The following is the detail of accomplishing it.

Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pops up.


Step 2: Click "Option" to open the Project Option, you can select the Object Types (Schemas) to compare. Click "OK" to continue.


Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database schemas.


Step 4: Click "Synchronize", you can find the differences of schemas shown on the script.

Step 5: Click "Sync" to synchronize the schemas. Then you will find the "Action" status changed from "Action_1" to "Action_2.jpg".

Step 6: Click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.


Tag: database schema compare,compare database schemas,synchronize sql

Readers also visit these :

Related Questions :

Reviews & Award

  • "I love using this instead of gonig through the Microsoft wizard"

    - by John

  • "Reliable and simple to backup MSSQL, good for backup databases from one PC to another easily. "

    - by Paul