Checking the Database Compatibility Type
MySQL -> GaussDB(DWS) Synchronization
Check Item |
Whether the database compatibility type is supported |
---|---|
Description |
The migration of tables without primary keys does not support the Oracle (ORA) compatibility mode of DWS. |
Failure Cause and Handling Suggestion |
Failure cause: The migration of tables without primary keys does not support the ORA compatibility mode of GaussDB(DWS). Handling suggestion: Use the MySQL and Teradata compatibility mode of GaussDB(DWS) or add primary keys to tables that do not have primary keys. Run the following statement to add a primary key to the table: CREATE DATABASE mysql_compatible_db DBCOMPATIBILITY 'MYSQL'; Or: CREATE DATABASE td_compatible_db DBCOMPATIBILITY 'TD'; |
MySQL to GaussDB(for openGauss) Synchronization
Check Item |
Whether the database compatibility type is supported |
---|---|
Description |
The destination database is incompatible with MySQL. |
Failure Cause and Handling Suggestion |
Failure cause: The destination database is incompatible with MySQL. Handling suggestion: Use a destination instance that is compatible with MySQL. If the destination instance is a distributed instance, run the following statement to create a compatible database: CREATE DATABASE mysql_compatible_db DBCOMPATIBILITY 'MYSQL'; If the destination instance is a primary/standby instance, run the following statement to create a compatible database: CREATE DATABASE mysql_compatible_db DBCOMPATIBILITY 'B'; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.