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.

Step 2: Click "Option" to open the Project Option, you can select the Object Types (Synonyms) 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 synonyms.

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

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

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

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)?
Technical Support
Latest News
- How to connect to SQ...
- How to install Datab...
- How to remove SQL Se...
- How to compare and s...
- How many database ob...
- How to compare and s...
Awards
Customer Service |
| If you have any question or suggestion,please contact us. |
| Get Help>> |
:
: 

