Home > News > How to compare and synchronize the differences of two database roles?

How to compare and synchronize the differences of two database roles?

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 (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


Tag: compare database roles,sql server data synchronization,database compared

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