Whether the Selected Objects Exist in the Destination Database

Whether the selected objects exist in the destination database

Check whether the objects in the source database are consistent with those in the destination database.

Failure cause: Object names will be converted to lowercase letters after being synchronized to the destination database. To avoid synchronization failures, ensure that the selected source database tables do not contain columns with the same name but different letter cases.

Handling suggestion: Delete columns with the same name but different letter cases from the source database tables, or change the names of columns with the same name but different letter cases in the source database tables.

Item to be confirmed: The selected table does not exist in the destination database or the table structure is inconsistent with that in the source database.

Handling suggestion: If the selected table does not exist in the destination database, create the table in the destination database and ensure that the table structure is the same as that in the source database. Statement for creating a table:

CREATE TABLE table_name (column_name data_type);

If the table structure is inconsistent with that in the source database, create missing columns in the destination database table, convert the names of columns with the same name but different letter cases in the destination database table to lowercase letters, or delete redundant columns from the source database table.

Item to be confirmed: The constraints on the destination database are inconsistent with those on the source database. The synchronization may fail due to inconsistent constraints.

Handling suggestion: Ensure that the constraints on the destination database are consistent with those on the source database, or confirm that inconsistent constraints do not adversely affect data migration.