Home > News > How to comapre and synchronize the synonyms?

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


Tag: synonyms compare and synchronize,database compare

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