When do I need to synchronize manually? And how to synchronize manually?

When you can't synchronize the table structure automatically, you need to do it manually. Most of the time, failing to synchronize is due to the same structure table in different fields of the attribute value, or the primary key fields are different. Such as blow:

product_added_script

Click "Sync" button, this time the error occurrs. The Error message shows you below:

errorinfo

To sychronize the table structure manually ,go through the following steps.

First, you need to open the SQL Query Analyzer, connect to the database server. Then click "OK" to login.

connect to SQL Server

Second, select the target database, then copy the code from the compared script result.

synchronize_script

Third, each time you can execute one section of the script. After these, you can click "Compare" to certify the manually synchronized result.

manually synchronized



: How to compare and synchronize the stored procedures of two databases?
: How to synchronize automatically?



Tags: database compare   synchronize manually  sql server database synchronization  

Readers also visit these:

What is data, database (DB), DBMS and DBS?
How to compare and synchronize the data in different database tables?
What is date type?
How to install Database Compare in my local disk?
What is T-SQL (Transact-SQL)?

Related Questions:

What is Database Integrity?
What is T-SQL (Transact-SQL)?
What is data, database (DB), DBMS and DBS?
What is role?
What is data backup and data recovery?