Create a Migration Task

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

Call us

400-151-8800

Email us

cloud@pingan.com

Online customer service

Instant reply

Technical Support

cloud products