Help Center> Database and Application Migration UGO> User Guide> Object Migration> Editing Conversion Configurations> Editing the Configurations During Migration from MySQL to GaussDB
Updated on 2022-12-08 GMT+08:00

Editing the Configurations During Migration from MySQL to GaussDB

Symptom

Feature Name

Recommended Setting

GaussDB does not support CHARSET in CREATE TABLE statements.

CHARSET

Comment CHARSET.

GaussDB does not support COLLATE in CREATE TABLE statements.

COLLATE

Comment COLLATE.

GaussDB does not support SECURITY clauses in views.

SECURITY clauses

Migrate SECURITY clauses.

GaussDB does not support CHECK OPTION clauses in views.

CHECK OPTION clauses

Migrate CHECK OPTION clauses.

In GaussDB, there are multiple types of integer variables.

INTEGER data type

Convert the data type to NUMERIC.

GaussDB does not support LONGTEXT data type in CREATE TABLE statements.

LONGTEXT data type

Convert LONGTEXT to TEXT. The script will be migrated and a warning message will be displayed.

GaussDB does not support LONGBLOB data type in CREATE TABLE statements.

LONGBLOB data type

Convert LONGBLOB to TEXT. The script will be migrated and a warning message will be displayed.

GaussDB does not support REAL data type in CREATE TABLE statements.

REAL data type

Convert REAL to DOUBLE PRECISION.

GaussDB does not support ON UPDATE in columns of tables.

ON UPDATE

Comment ON UPDATE.

The distributed GaussDB does not support generated columns.

Generated columns

NOTE:

This feature is available only in distributed GaussDB.

Comment generated columns.

In GaussDB, multiple columns cannot be used as the partition key in a table.

Multi-column partition keys of partitioned tables

Use the first column of the primary key or unique key as the partition key.

In GaussDB, partition keys cannot be same as sub-partition keys.

Same partition keys and sub-partition keys

Comment SUB partitions.

GaussDB temporary tables do not support AUTO INCREMENT.

AUTO INCREMENT in temporary tables

Comment AUTO INCREMENT.

Distributed GaussDB does not support FOREIGN KEY constraints.

FOREIGN KEY constraints

NOTE:

This feature is available only in distributed GaussDB.

Comment FOREIGN KEY constraints.

The character set length of GaussDB is different from that of MySQL.

Character set length conversion

Comment or extend character datatype length.

In distributed GaussDB, distribution keys are part of the constraints.

Unique constraints and indexes in a distributed environment

NOTE:

This feature is available only in distributed GaussDB.

If no distribution key exists in a unique constraint and unique index, add a distribution key.

GaussDB does not support DEFINER in database objects.

Definer

If a user is specified when an object is created, convert it to ALTER OWNER.

GaussDB ignores SQL parsing.

Parsing converted SQL statements

Ignore parsing.

In GaussDB, Ustore tables do not support B-tree indexes.

B-tree index conversion

NOTE:

This feature is available only in centralized GaussDB.

If enable_default_ustore_table of the target database version is set to OFF, generate common tables during table creation and support B-tree indexes.