Checking Whether the SQL_MODE Values of the Source and Destination Databases Are the Same

**Table 1** Checking whether the SQL_MODE values of the source and destination databases are the same
Check Item	Whether the SQL_MODE values of the source and destination databases are the same
Description	Check whether the SQL_MODE values of source and destination databases are the same. If they are inconsistent, the migration may fail.
Failure Cause and Handling Suggestion	If you are migrating data to the cloud, perform the following operations: Failure cause: The SQL_MODE values of the source and destination databases must be the same. Handling suggestion: Change the SQL_MODE values of the destination database to the same as those of the source database, Ensure that both the source and destination databases do not have the forbidden SQL_MODE values. For details, see Modifying Parameters. If MyISAM tables are to be migrated, the SQL_MODE values in the destination database cannot contain NO_ENGINE_SUBSTITUTION. If you are migrating data out of the cloud, perform the following operations: Item to be confirmed: The SQL_MODE values of the source and destination databases must be the same. Handling suggestions: Change the SQL_MODE values of the destination database to the same as those of the source database. Ensure that both the source and destination databases do not have the forbidden SQL_MODE values.