The RDS console includes a built-in data migration feature powered by Data Transmission Service (DTS). Use it to migrate data into or out of your ApsaraDB RDS for MySQL instance without leaving the console.
Prerequisites
Before you begin, ensure that you have:
-
An ApsaraDB RDS for MySQL instance. To create one, see Create an ApsaraDB RDS for MySQL instance.
-
If your source database is on an on-premises device or a third-party cloud platform: added the CIDR blocks of the required DTS servers to the IP address whitelist of your self-managed MySQL instance. See Add the CIDR blocks of DTS servers or What is DTS?
-
A source or destination database created based on your business requirements. If your RDS instance is the destination, its available storage must exceed the storage capacity of the source instance. To expand storage, see Change instance specifications.
Enable the automatic storage expansion feature so the system automatically expands storage when available space drops below your specified threshold. See Use the automatic storage expansion feature.
-
DTS authorized to access Alibaba Cloud resources. See Authorize DTS to access Alibaba Cloud resources.
Billing
This feature is provided by DTS and shares the same billable items as DTS. See Billable items.
Create a data migration task
Step 1: Open the data migration page
-
Go to the Instances page.
-
In the top navigation bar, select the region where your RDS instance resides. Find the instance and click its instance ID.
-
In the left-side navigation pane, click Data Migration and Synchronization.
-
Click the Data Migration tab, then click Create Data Migration Task.
Step 2: Configure source and destination databases
If the current RDS instance is the source or destination, the Instance Region and RDS Instance ID parameters are automatically filled in and cannot be modified.
Configure the source database:
-
Set the Database Account and Database Password parameters.
-
Set the Encryption parameter.
Configure the destination database:
-
Set the Database Type and Access Method parameters.
-
Set the Instance Region and RDS Instance ID parameters.
-
Set the Encryption parameter.
Click Test Connectivity and Proceed to verify the connection before moving on.
Step 3: Configure objects
This step follows the same configuration as the original DTS console. The new DTS console has an optimized experience. See [Notice] DTS console fully upgraded.
-
Set Migration Types. Choose based on whether your source database can go offline during migration: To migrate with minimal downtime: select both Full Data Migration and Incremental Data Migration. The task performs a full load first, then continuously applies changes until you cut over.
Migration type What it does When to use Schema Migration Migrates database schemas (tables, indexes, constraints) without data Run first if you need to create the target schema before migrating data Full Data Migration Copies all existing data from the source to the destination at a point in time Use when your source database can go offline during migration, or for an initial bulk load Incremental Data Migration Captures and applies ongoing changes (inserts, updates, deletes) from the source after the full data migration completes Use when your source database cannot go offline, or when you need near-zero downtime migration -
Set Processing Mode of Conflicting Tables:
-
Precheck and Report Errors: DTS checks for table conflicts before starting. If conflicts are found, the task stops and reports the errors. Use this mode when data integrity is critical and you want to resolve conflicts before migration begins.
-
Ignore Errors and Proceed: DTS skips conflicting tables and continues migrating the rest. Use this mode when you accept partial conflicts and prefer the task to continue without interruption.
-
-
Set Capitalization of Object Names in Destination Instance to control whether database names, table names, and column names are capitalized in the destination. By default, DTS default policy is selected. To make capitalization match your source or destination database, select another option. See Specify the capitalization of object names in the destination instance.
-
In the Source Objects section, select the objects to migrate and move them to the Selected Objects section.
-
To rename objects in the destination instance, click the object name inline. To rename multiple objects at once, click Batch Edit in the upper-right corner.
-
(Optional) Click Advanced Settings (Optional) to configure advanced parameters: Use the following references for parameter details based on your source and destination: For cross-account migrations, see Migrate data between ApsaraDB RDS instances of different Alibaba Cloud accounts.
-
In Data Verification Settings, set Data Verification Mode. The available options depend on the migration types selected in step 1.
-
In Advanced Settings, configure any remaining parameters based on your requirements. These settings and subsequent steps match the DTS console experience.
From ApsaraDB RDS for MySQL:
To ApsaraDB RDS for MySQL:
-
FAQ
**What do I do if the DTS-RETRY-ERR-0069: Datasource rejected establishment of connection (.*)? Too many connections error appears?**
The source or destination database has reached its maximum connection limit. Increase the maximum number of connections on the affected database, then restart the migration task.
For other DTS errors, see Common errors and troubleshooting.