How to compare and synchronize the differences of two database roles?
Step 1: Open DataBase Compare, click "Connection" button, then the connection dialog pops up.

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

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

Step 5: Click on "Sync", then you will be prompted to backup the target database. If you want to backup your database manually, please choose "No" in the confirm dialog.

Step 6: Click "Yes" and you will see the action status changed from "

: How to compare and synchronize the differences of two database full text catalogs?
: How to compare and synchronize two database users?
Tags: compare database roles sql server data synchronization database compared
Readers also visit these:
How to compare and synchronize the data in different database tables?Can you show me the commands in each tab in the main interface?
How to compare and synchronize the permissions?
How to compare and synchronize two database users?
How to compare and synchronize the differences of two database triggers?
Related Questions:
What is data model?What is Database Integrity?
What is data storage?
What is T-SQL (Transact-SQL)?
Technical Support
Latest News
- Can you show me the ...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- How to compare and s...
- Which license is bes...
Awards
Customer Service |
| If you have any question or suggestion,please contact us. |
| Get Help>> |


