You are here: Home > FAQ > FAQ More

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.

connection

Step 2: Click "Option" to open the Project Option, you can select the Object Types (Roles) to compare. Click "OK" to continue.

roles_option

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

roles_compare

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

roles_synchronize

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.

backup_prompt

Step 6: Click "Yes" and you will see the action status changed from "Action_1" to "Action_2". This tells you that the synchronization has been completed successfully.

roles_sync


: 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)?