Basic Procedure
After you purchase an eSurfing Cloud DTS data migration instance, the instance is in the To be configured state by default. To perform data migration, you must configure the instance.
Before You Begin
You have prepared the source database instance.
You have purchased an eSurfing Cloud DTS instance.
You have prepared other required items.
Procedure
Log in to the eSurfing Cloud official website and go to the DTS console.
Go to the Instance List page that displays data migration instances.
Locate the instance that you want to configure and click Configure.
Enter the information required for database connection and perform connectivity testing.
Click Next and select the objects that you want to migrate. You can select to migrate the entire database or some tables in the database.
Precheck.
During prechecking, DTS checks some key configuration items of the source and destination databases.
Note:
You must handle all alarms or failures displayed on the Precheck page. Otherwise, the migration task may fail.
After handling all alarms and failures, go to Data Migration > Instance Management to submit a precheck request again.
After the task passes the precheck, it is in the Not started state.
Configuring Objects and Advanced Settings
Click Configure or Edit. In Step 2, you can configure the objects and advanced settings.
Selecting Migration Steps
In the Configurations section, select the migration steps to be performed. Struct Migration is a required option.
Note:
If the destination database already contains some objects with the names that are the same as the names of some migration objects, DTS skip these objects during structure migration. If these objects are tables, make sure that the structures of the tables in the destination database are consistent with those in the source database. Otherwise, full data migration and incremental data migration may fail.
If the destination database already contains tables with the same names of some source tables, and the tables already contain data rows with the primary key values that are the same as those of these source tables, these data rows in the destination database will be overwritten during full data migration.
Selecting Migration Objects
In Step 2 of instance configuration, the objects that you can select are displayed in the Source Database Objects box. For example, if you migrate data between MySQL databases, the database-level object is displayed by default.
Click the expand icon on the left side of the database-level object. A confirmation message that notifies you of database migration appears. To select some objects to be migrated, click OK.
After objects in the source databases are displayed, you can select migration objects at the child levels. For example, you can select all the tables as migration objects.
Click the > icon in the middle. The selected objects are moved to the left-side box as migration objects.
Note:
If you do not expand the database object hierarchies but select the database-level object, the system migrates the entire database.
To migrate the structures of tables created during task execution to the destination database in the incremental data migration stage, select Incremental Data Migration, Incremental DDL Statements, and the database-level object.
Edit Database
Click Edit on the right side of a selected object.
The page for editing the object information pops up.
Changing the Database Name
On the Edit Database page, you can change the database name.
Click OK. The new name is displayed as the database name, and the original database name is displayed in the orange color on the right side.
Note:
After the change, the new name is used as the name of the destination database. A database name can contain only letters, digits, underscores (_), and dollar signs ($).
If you select to migrate the entire database, after you click Edit, a message notifying that you cannot configure name mapping for the database, or tables or columns in the database is prompted.
Select DML Operations for Migration
When you select Incremental Data Migration, you can select the DML operations that need to be migrated during incremental data migration.
Note:
If Incremental Data Migration is not selected, this feature is disabled.
The configuration of this feature set on the Edit Table page will overwrite that set on the Edit Database page.
Editing a Table
After you select a table as a migration object, you can click Edit on the right side of the table.
The table editing page appears.
Changing the Table Name
On the Edit Table page, you can change the table name.
Click OK. The new name is displayed as the table name, and the original table name is displayed in the orange color on the right side.
Note:
After the change, the new name is used as the table name. A table name can contain only letters, digits, underscores (_), and dollar signs ($).
If you select Incremental Data Migration and the source database is a PostgreSQL database, the table name cannot be changed.
Setting Filter Conditions
On the Edit Table page, set the filter conditions to filter the table data during the full data migration.
Note:
Semicolons (;) and two consecutive hyphens (--) are not supported in the filter conditions.
Only the data that meets the conditions specified in the WHERE clause will be migrated to the destination database.
Selecting DML Operations for Migration
When you select Incremental Data Migration, you can select the DML operations that need to be migrated during incremental data migration on the Edit Table page.
Note:
If Incremental Data Migration is not selected, this feature is disabled.
The configuration of this feature set on the Edit Table page will overwrite that set on the Edit Database page.
Changing the Column Names
When Incremental Data Migration is not selected, you can change the table column names on the Edit Table page.
Note:
If you select Incremental Data Migration, this feature is disabled.
If you change the column names, the corresponding table column names in the destination database will be changed to the new names as specified.
Deleting a Column
When Incremental Data Migration is not selected, you can deselect a certain column from a table to delete the column on the Edit Table page.
Note:
If you select Incremental Data Migration, this feature is disabled.
If a certain column is not selected, the corresponding column in the destination database does not exist.
If a primary key column is not selected, duplicate data may exist during the full data migration. You are not recommended to perform this operation.
Batch Editing Names
Click Batch Edit on the right side of the selected objects.
Then, the Batch Edit dialog box appears.
Select a table renaming rule. (Currently, only one rule is available to add a prefix and a suffix.) Then, select objects to be edited, enter the prefix and suffix, and click OK.
The prefix and suffix is added to all the table names.
Note:
Currently, you can only batch edit database and table names, and cannot batch edit other objects.
If the entire database is to be migrated, or the database contains EVENT/TRIGGER objects, you are prompted that the database is an empty object and therefore the objects cannot be batch edited on the Batch Edit page.
If you select Incremental Data Migration and the source database is a PostgreSQL database, you cannot batch edit objects.