How to compare and synchronize the schemas?

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.

Step 5: Click "Sync" 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.