github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/docs/user_docs/kubeblocks-for-mysql/migration/feature-and-limit-list-mysql.md (about)

     1  ---
     2  title: Full feature and limit list
     3  description: The full feature and limit list of KubeBlocks migration function for PostgreSQL
     4  keywords: [postgresql, migration, migrate data in PostgreSQL to KubeBlocks, full feature, limit]
     5  sidebar_position: 1
     6  sidebar_label: Full feature and limit list
     7  ---
     8  
     9  # Full feature and limit list
    10  
    11  ## Full feature list
    12  
    13  * Precheck
    14    * Database connection
    15    * Database version
    16    * Whether the incremental migration is supported by a database
    17    * The existence of the table structure
    18    * Whether the table structure of the source database is supported
    19  * Structure initialization
    20    * PostgreSQL
    21      * Table Struct
    22      * Table Constraint
    23      * Table Index
    24      * Comment
    25  * Data initialization
    26    * Supports all major data types
    27  * Incremental data migration
    28    * Supports all major data types
    29    * Support the resumable upload capability of eventual consistency
    30  
    31  ## Limit list
    32  
    33  * Overall limits
    34    * If the incremental data migration is used, the source database should enable CDC (Change Data Capture) related configurations (both are checked and blocked in precheck).
    35    * A table without a primary key is not supported. And a table with a foreign key is not supported (both are checked and blocked in precheck).
    36    * Except for the incremental data migration module, other modules do not support resumable upload, i.e. if an exception occurs in this module, such as pod failure caused by downtime and network disconnection, a re-migration is required.
    37    * During the data transmission task, DDL on the migration objects in the source database is not supported.
    38    * The table name and field name cannot contain Chinese characters and special characters like a single quotation mark (') and a comma (,).
    39    * During the migration process, the switchover of primary and secondry nodes in the source library is not supported, which may cause the connection string specified in the task configuration to change. This further leads to migration link failure.
    40  * Precheck module: None
    41  * Structure initialization module
    42    * The user-defined type is not supported.
    43    * The database character set other than UTF-8 is not supported.
    44  * Data initialization module
    45    * Character sets of the source and sink databases should be the same.
    46  * Data incremental migration module
    47    * Character sets of the source and sink databases should be the same.