To compare and synchronize the differences of two database defaults, you can go through the following steps. The screenshots can be good guider for you.
Step 1: Open SQL Server Comparison Expert, click "Connection" button, then the connection dialog pop up.
Step 2: Click "Option" to open the Project Option, you can select the Object Types (Defaults) to be compared. Click "OK" to continue.
Step 3: Click "OK" in the connection dialog, select the "Compare" button to compare the differences between the two database defaults.
You will find the differences in the compared strcture results. Click "Synchronize
", you'll see the script which can make the two database defaults have no differences.
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.
" and you will see the action status changed from "
", this told you that the synchronization has been completed successfully.