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.


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


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


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


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.


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