This topic describes how to migrate data from an ApsaraDB RDS for PostgreSQL instance to an ApsaraDB RDS for MySQL instance by using Data Transmission Service (DTS). DTS supports full data migration and incremental data migration. When you configure a data migration task, you can select both supported migration types to ensure service continuity.
Supported source and destination databases
You can use DTS to migrate data between the following types of PostgreSQL and MySQL databases. This topic describes how to migrate data from an ApsaraDB RDS for PostgreSQL instance to an ApsaraDB RDS for MySQL instance. You can follow the procedure to configure data migration tasks for other scenarios.- Migrate data from an ApsaraDB RDS for PostgreSQL instance to an ApsaraDB RDS for MySQL instance
- Migrate data from a self-managed PostgreSQL database to a self-managed MySQL database
Prerequisites
- The source ApsaraDB RDS for PostgreSQL instance is created. For more information, see Create an ApsaraDB RDS for PostgreSQL instance.
- The destination ApsaraDB RDS for MySQL instance is created. For more information, see Create an ApsaraDB RDS for MySQL instance.
- The available storage space of the destination ApsaraDB RDS for MySQL instance is larger than the total size of the data in the source ApsaraDB RDS for PostgreSQL instance.
Usage notes
Category | Description |
---|---|
Limits on the source database |
|
Other limits |
|
Special cases |
|
Billing
Migration type | Instance configuration fee | Internet traffic fee |
---|---|---|
Full data migration | Free of charge. | Charged only when data is migrated from Alibaba Cloud over the Internet. For more information, see Billing overview. |
Incremental data migration | Charged. For more information, see Billing overview. |
Migration types
- Full data migration
DTS migrates historical data of required objects from the source database to the destination database.
- Incremental data migration
After full data migration is complete, DTS migrates incremental data from the source database to the destination database. Incremental data migration allows you to ensure service continuity when you migrate data between self-managed databases.
SQL operations that can be migrated
Operation type | SQL statement |
---|---|
DML | INSERT, UPDATE, and DELETE |
Permissions required for database accounts
Database | Full data migration | Incremental data migration | References |
---|---|---|---|
ApsaraDB RDS for PostgreSQL instance | SELECT permission on the objects to be migrated | Permissions of a privileged account. The account must be the owner of the database.
Note If the version of the source ApsaraDB RDS for PostgreSQL instance is 9.4 and you migrate
only DML operations, only the REPLICATION permission is required for the database
account.
|
Create an account on an ApsaraDB RDS for PostgreSQL instance and Create a database on an ApsaraDB RDS for PostgreSQL instance |
ApsaraDB RDS for MySQL instance | Read and write permissions | Create an account on an ApsaraDB RDS for MySQL instance and Modify the permissions of a standard account on an ApsaraDB RDS for MySQL instance |