You are here: Home > FAQ > FAQ More

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


: Can you show me the commands in each tab in the main interface?
: How to compare and synchronize the partition functions?


Tags: compare sql server databases   synchronize database permissions   synchronizing database  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
Can you show me the commands in each tab in the main interface?
Which license is best for me?
How to install Database Compare in my local disk?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?