<p><strong><span style="font-size:18px">Function Limitations</span></strong></p> <ol> <li>When you pause a migration task, the synchronization of the table that is being synchronized will not stop until the synchronization finishes or fails. When you restart the migration task, the tables that have been already synchronized will not be migrated again.</li> <li>To maximize performance, DTS automatically assigns migration tasks to the availability zone or region of the target database.</li> <li>To view the monitoring information of migration tasks, use the Ping An Cloud Argus service or log in to the DTS console to view logs.</li> <li>When a migration task fails, it cannot automatically restart. You can view the failure log, troubleshoot the issue, and then manually restart the task.</li> <li>As a best practice, make sure the number of tables in a migration task does not exceed 1000.</li> </ol> <p><strong><span style="font-size:18px">Structure Migration Limitations</span></strong></p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Source database</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Target database</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Table structures</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Views</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Functions</strong></p> </td> <td style="background-color:#ededed; vertical-align:top"> <p><strong>Stored procedures</strong></p> </td> </tr> <tr> <td style="vertical-align:top"> <p>MySQL</p> </td> <td style="vertical-align:top"> <p>MySQL</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>MySQL</p> </td> <td style="vertical-align:top"> <p>PostgreSQL</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>PostgreSQL</p> </td> <td style="vertical-align:top"> <p>PostgreSQL</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td style="vertical-align:top"> <p>PostgreSQL</p> </td> <td style="vertical-align:top"> <p>MySQL</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> </tbody> </table> <p><strong><span style="font-size:18px">Field Type Limitations in Structure Migration</span></strong></p> <p>Structure migration does not support migrating the following field types:</p> <table border="1" cellpadding="0" cellspacing="0" style="width:375px"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:133px"> <p><strong>Database types</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:237px"> <p><strong>Unsupported field types </strong></p> </td> </tr> <tr> <td rowspan="6" style="vertical-align:top; width:133px"> <p>MySQL</p> </td> <td style="width:237px"> <p>BIT</p> </td> </tr> <tr> <td style="width:237px"> <p>LONGTEXT</p> </td> </tr> <tr> <td style="width:237px"> <p>POINT</p> </td> </tr> <tr> <td style="width:237px"> <p>LINESTRING</p> </td> </tr> <tr> <td style="width:237px"> <p>POLYGON</p> </td> </tr> <tr> <td style="width:237px"> <p>LINESTRING</p> </td> </tr> <tr> <td rowspan="20" style="vertical-align:top; width:133px"> <p>PostgreSQL</p> </td> <td style="width:237px"> <p>XML</p> </td> </tr> <tr> <td style="width:237px"> <p>JSON</p> </td> </tr> <tr> <td style="width:237px"> <p>TSVECTOR</p> </td> </tr> <tr> <td style="width:237px"> <p>TSQUERY</p> </td> </tr> <tr> <td style="width:237px"> <p>ARRAY</p> </td> </tr> <tr> <td style="width:237px"> <p>POINT</p> </td> </tr> <tr> <td style="width:237px"> <p>LINE</p> </td> </tr> <tr> <td style="width:237px"> <p>LSEG</p> </td> </tr> <tr> <td style="width:237px"> <p>BOX</p> </td> </tr> <tr> <td style="width:237px"> <p>PATH</p> </td> </tr> <tr> <td style="width:237px"> <p>POLYGON</p> </td> </tr> <tr> <td style="width:237px"> <p>CIRCLE</p> </td> </tr> <tr> <td style="width:237px"> <p>TXID_SNAPSHOT</p> </td> </tr> <tr> <td style="width:237px"> <p>CIDR</p> </td> </tr> <tr> <td style="width:237px"> <p>INET</p> </td> </tr> <tr> <td style="width:237px"> <p>MACADDR</p> </td> </tr> <tr> <td style="width:237px"> <p>BIT</p> </td> </tr> <tr> <td style="width:237px"> <p>OID</p> </td> </tr> <tr> <td style="width:237px"> <p>MONEY</p> </td> </tr> <tr> <td style="width:237px"> <p>INTERVAL</p> </td> </tr> </tbody> </table> <p><strong><span style="font-size:18px">Region Limitations</span></strong></p> <p>The following table lists the region support information for Ping An Cloud DTS data migration when both the source and target databases are RDS databases:</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed"> <p><strong>Source database regions</strong></p> </td> <td style="background-color:#ededed"> <p><strong>Target database regions</strong></p> </td> <td style="background-color:#ededed"> <p><strong>Whether data migration is supported</strong></p> </td> </tr> <tr> <td rowspan="3"> <p>East China</p> </td> <td> <p>East China</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td> <p>South China</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td> <p>Hong Kong</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> <tr> <td rowspan="3"> <p>South China</p> </td> <td> <p>South China</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td> <p>East China</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td> <p>Hong Kong</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> <tr> <td rowspan="3"> <p>Hong Kong</p> </td> <td> <p>Hong Kong</p> </td> <td style="vertical-align:top"> <p>Supported</p> </td> </tr> <tr> <td> <p>East China</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> <tr> <td> <p>South China</p> </td> <td style="vertical-align:top"> <p>Not supported</p> </td> </tr> </tbody> </table>