平安云|Ping An Cloud- Building Your Smart Future

Create a Migration Task

Data migration tasks transmit data between databases. This article describes how to create a data migration task. Prerequisites You have successfully created the source and target databases. Procedures 1.     Create a migration task.         a)      Log in to the <a href="http://pinganyun.com/console/dts/overview" target="_blank">DTS Console</a>.         b)      In the left navigation pane, click Migration Task to enter the Migration Task Management page.         c)      Click Create in the upper-right corner of the page to enter the Create Migration Task page. 2.     Configure the source and target databases.         a)      Configure the source and target databases as described in the following table: <table border="1" cellpadding="0" cellspacing="0" style="width:0px"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top"> Configuration item </td> <td style="background-color:#ededed; vertical-align:top"> Description </td> </tr> <tr> <td style="vertical-align:top"> Instance Type </td> <td style="vertical-align:top"> Select types of the source and target databases. </td> </tr> <tr> <td style="vertical-align:top"> Instance Region </td> <td style="vertical-align:top"> Select regions where the source and target databases are located. </td> </tr> <tr> <td style="vertical-align:top"> RDS Instance ID </td> <td style="vertical-align:top"> Select instance IDs of the source and target databases. </td> </tr> <tr> <td style="vertical-align:top"> Database Name </td> <td style="vertical-align:top"> For RDS MySQL databases, you do not need to configure this parameter. </td> </tr> <tr> <td style="vertical-align:top"> Database Account </td> <td style="vertical-align:top"> Enter account names of the source and target databases. </td> </tr> <tr> <td style="vertical-align:top"> Database Password </td> <td style="vertical-align:top"> Enter the passwords of the source database account and of the target database account. </td> </tr> </tbody> </table>         b)      Click Test The Connection to test the connectivity between the source and target databases.         c)      Click Next Step after the test succeeds. 3.     Configure the migration type.         a)      Select the target migration objects, for example, tables, views, functions, and procedures.         b)      Select a migration type. <ul> <li>If the target database is empty, you must select Structure Transfer.</li> <li>If you want the migration task to be performed with zero downtime, select Full Migration, Structure Transfer, and Increment Transfer.</li> <li>If you want to migrate only the new data, select Increment Transfer.</li> </ul>         c)      Click the right arrow icon <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707094419-1f2737b79044.png" style="height:18px; margin:0px; width:20px" /> . <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707094512-1e787c909897.png" style="height:452px; width:830px" /> 4.     Precheck.         a)      Click Precheck and Start to enter the Precheck page.         b)      The system will examine every precheck item. If the precheck fails, modify configuration and run the precheck again until the result is a 100% pass. To troubleshoot a precheck failure, see Troubleshoot Precheck Failures. <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707110508-14d9d95090f3.png" style="height:440px; width:830px" />         c)      Click Next Step to enter the Migration Configuration page. 5.     Set the specification of the migration channel.         a)      Select a specification for the migration channel. For more information, see Specifications of Data Migration Channels. <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200707110619-1ccb751b9a2b.png" style="height:360px; width:450px" />         b)      DTS is at the open beta stage, you can have a free trail.         c)      Click Purchase and Open to enter the Order Confirmation page and confirm DTS information. 6.     Click Confirm Open. Result Method 1: On the Payment Result page, click View Order to enter the Product Order page. The Status of the target order becomes Finished. Method 2: In the left navigation pane, click Migration Task to enter the Migration Task Management page. Select the target region, and you can view the migration task that has been created and its migration progress. This section uses a task that contain structure migration, full migration, and incremental migration as an example. The migration progress is as follows: <ul> <li>Structure migration: Finished</li> <li>Full migration: Finished</li> <li>Incremental migration: Not Delayed</li> </ul>

Did the above content solve your problem? Yes No