Basic Procedure
After you purchase an eSurfing Cloud DTS data synchronization instance, the instance is in the To be configured state by default. To perform data synchronization, 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 synchronization 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 synchronize. You can select to synchronize the entire database or some tables in the database.
If you want to synchronize the entire database, directly select the database without the need to expand it. If you need to select certain objects in the source database, expand the source database and configure the objects to be synchronized as needed.
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 the Data Migration > Instance Management page or the instance editing page to submit a precheck request again.
After the task passes the precheck, it is in the Not started state.
Details About Configuring Synchronization Objects and Advanced Settings
Click Configure or Edit. In Step 2, you can configure the objects and advanced settings.
Selecting Synchronization Steps
In the Configurations section, select the synchronization steps to be performed. You must select struct synchronization and incremental data synchronization.
Note:
If the destination database already contains some objects with the names that are the same as the names of some synchronization objects, DTS skip these objects during structure synchronization. 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 synchronization and incremental data synchronization 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 synchronization.
If you go to the editing page, you cannot change the confirmed synchronization steps.
Selecting Synchronization 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 synchronize 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 synchronization appears. To select some objects to be synchronized, click OK.
After objects in the source databases are displayed, you can select synchronization objects at the child levels. For example, you can select all the tables as synchronization 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 synchronizes the entire database.
To synchronize the structures of tables created during task execution to the destination database in the incremental data synchronization stage, select Incremental Data Sync, 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.
If you 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 synchronize 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 Sync, you can select the DML operations that need to be synchronized during incremental data synchronization.
Note:
If Incremental Data Sync 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 Sync and the source database is a PostgreSQL database, the table name cannot be changed.
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 synchronized to the destination database.
Selecting DML Operations for Migration
When you select Incremental Data Sync, you can select the DML operations that need to be synchronized during incremental data synchronization on the Edit Table page.
Note:
If Incremental Data Sync 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 Sync is not selected, you can change the table column names on the Edit Table page.
Note:
If you select Incremental Data Sync, 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 Sync is not selected, you can delete a certain column from a table on the Edit Table page.
Note:
If you select Incremental Data Sync, 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 Edit
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 synchronized, 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 Sync and the source database is a PostgreSQL database, you cannot batch edit objects.