How to comapre and synchronize the synonyms?

Refer to the following screenshots to accomplish comparison and synchronization the synonyms of two databases.

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 (Synonyms) to compare. Click "OK" to continue.

synonyms_option

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

synonyms_compare

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

synonyms_synchronize

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

synonyms_sync

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

synonyms_sychronized_compare



: How to compare and synchronize contracts?
: How to compare and synchronize the schemas?



Tags: synonyms compare and synchronize   database compare  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Can you show me the commands in each tab in the main interface?
Which license is best for me?
What is date type?

Related Questions:

What is Database Integrity?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?
What is view (database)?