You are here: Home > FAQ > FAQ More

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:

How to compare and synchronize the data in different database tables?
What is data, database (DB), DBMS and DBS?
How can I get technical support?
How to install Database Compare in my local disk?
What is date type?

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?