Home > News > How to compare and synchronize the permissions?

How to compare and synchronize the permissions?

To compare and synchronize the permissions of two databases, you can go through the following steps.

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 (Permissions) to compare. Click "OK" to continue.

permissions_option

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

permissions_compare

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

permissions_synchronize

Step 5: Click "Sync" to synchronize the permissions. Then you will find the "Action" status changed from "Action_1" to "Action_2.jpg".

permissions_sync

Step 6: Click "Structure Result", and then click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.

permissions_sychronized_compare


Tag: compare sql server databases,synchronize database permissions,synchronizing database

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