Checking Whether the Values in the Source Oracle Database Are Out of the Ranges of the MySQL Database

Item to Be Confirmed

• Ensure that the columns that use character strings as primary keys or unique keys in the table to be migrated do not contain spaces. If the source database uses character strings as primary keys or unique keys, it will support spaces, but the destination database will not. As a result, there may be data inconsistencies or the migration may fail.
• Due to differences between the source and destination databases, the migration will fail if the values of the following data types in the source database are out of the ranges of the destination database: number, int, float, double, date, and timestamp.
• When a non-accurate data type is used as a primary key, there may be data inconsistencies due to database compatibility.

Handling Suggestion

Check whether the preceding problems occur. You need to determine whether to solve the problems as required. You can also confirm the problems and go to the next step.