Limitations

Function Limitations

  1. When you pause a migration task, the synchronization of the table that is being synchronized will not stop until the synchronization finishes or fails. When you restart the migration task, the tables that have been already synchronized will not be migrated again.
  2. To maximize performance, DTS automatically assigns migration tasks to the availability zone or region of the target database.
  3. To view the monitoring information of migration tasks, use the Ping An Cloud Argus service or log in to the DTS console to view logs.
  4. When a migration task fails, it cannot automatically restart. You can view the failure log, troubleshoot the issue, and then manually restart the task.
  5. As a best practice, make sure the number of tables in a migration task does not exceed 1000.

Structure Migration Limitations

Source database

Target database

Table structures

Views

Functions

Stored procedures

MySQL

MySQL

Supported

Supported

Supported

Supported

MySQL

PostgreSQL

Supported

Not supported

Not supported

Not supported

PostgreSQL

PostgreSQL

Supported

Supported

Supported

Supported

PostgreSQL

MySQL

Supported

Not supported

Not supported

Not supported

Field Type Limitations in Structure Migration

Structure migration does not support migrating the following field types:

Database types

Unsupported field types

MySQL

BIT

LONGTEXT

POINT

LINESTRING

POLYGON

LINESTRING

PostgreSQL

XML

JSON

TSVECTOR

TSQUERY

ARRAY

POINT

LINE

LSEG

BOX

PATH

POLYGON

CIRCLE

TXID_SNAPSHOT

CIDR

INET

MACADDR

BIT

OID

MONEY

INTERVAL

Region Limitations

The following table lists the region support information for Ping An Cloud DTS data migration when both the source and target databases are RDS databases:

Source database regions

Target database regions

Whether data migration is supported

East China

East China

Supported

South China

Supported

Hong Kong

Not supported

South China

South China

Supported

East China

Supported

Hong Kong

Not supported

Hong Kong

Hong Kong

Supported

East China

Not supported

South China

Not supported

Did the above content solve your problem? Yes No
Please complete information!

Call us

400-151-8800

Email us

cloud@pingan.com

Online customer service

Instant reply

Technical Support

cloud products