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.

connection

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

schemas_option

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

schemas_compare

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.

shcemas_sychronized_compare


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