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 (Roles) toÂ compare. Click "OK" to continue.
" in the connection dialog, select the "Compare
" button to compare the differences between the two database roles.
Step 4: Click "Synchronize", you can find the differences of roles shown on the script.
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.
" and you will see the action status changed from "
" to "
". This tells you that the synchronization has been completed successfully.