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 Database Comparer, 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



: How to comapre and synchronize the synonyms?
: How to compare and synchronize the differences of two database message types?



Tags: database schema compare   compare database schemas   synchronize sql  

Readers also visit these:

How to compare and synchronize the data in different database tables?
Which license is best for me?
How to compare and synchronize the permissions?
How can I get technical support?
What is date type?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?