Home > News > How to compare and synchronize two database users?
How to compare and synchronize two database users?
The following contexts will teach you the steps of comparing and synchronizing two database users.
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 (Users) 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 databases users.
Step 4: Click "Synchronize", you can find the differences of users shown on the script.
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.
Step 6: Click "Yes" and you will find the action status changed from "
" to "
". This tells you that the synchronization has been completed successfully.
" to "". This tells you that the synchronization has been completed successfully.
Tag: database compare,compare sql database users,synchronize sql database users
How to compare and synchronize the differences of two database roles?
How to compare and synchronize two database functions?
Readers also visit these :
- How to install Database Compare in my local disk?
- How to compare and synchronize the differences of two database user-defined Data Types?
- How to compare and synchronize two database functions?
- How to compare and synchronize the differences of two database roles?
- How to compare and synchronize the differences of two database message types?
Related Questions :
Popular articles
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
