To compare and synchronize the schemas of two databases, you can use Schema Comarer or Database Comparer. The following is the detail of accomplishing it.
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 (Schemas) 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 schemas.
Step 4: Click "Synchronize", you can find the differences of schemas shown on the script.
" to synchronize the schemas. Then you will find the "Action
" status changed from "
" to "
Step 6: Click "Compare" button to check the result after synchronization. If you couldn't find differences, thus, the synchronization is completed sucessfully.