Checking Whether the Source Database Tables Contain Primary Keys

**Table 1** Checking whether the source database tables contain primary keys
Check Item	Whether the source database tables contain primary keys
Description	If tables to be migrated in the source database do not contain primary keys, the migration may fail.
Item to Be Confirmed and Handling Suggestion	Item to be confirmed: The tables to be migrated in the source database do not contain primary keys. Handling suggestion: Create a primary key for the table. If the table does not have a primary key to uniquely identify every row and the network connection is unstable, the data in the destination database may be inconsistent with that in the source database.

**Table 2** Checking whether the source database tables contain primary keys
Check Item	Whether the source database tables contain primary keys
Description	If tables to be synchronized in the source database do not contain primary keys, the synchronization may fail.
Failure Cause and Handling Suggestion	Failure cause: The tables to be synchronized in the source database do not contain primary keys. Handling suggestion: Create primary keys for the tables to improve performance.
Failure Cause and Handling Suggestion	Failure cause: In a many-to-one task, tables with no primary key that have the same name as those in the destination database are not allowed in the source database. Handling suggestion: Modify tables without primary keys, delete tables with no primary key from the destination database, or do not migrate tables without primary keys.
Item to Be Confirmed and Handling Suggestion	Item to be confirmed: The tables to be synchronized in the source database do not contain primary keys. Handling suggestion: Create a primary key for the table. If the table does not have a primary key to uniquely identify every row and the network connection is unstable, the data in the destination database may be inconsistent with that in the source database.