Section | Parameter | Description |
N/A | Task Name | The name of the task. DTS automatically generates a task name. We recommend that you specify an informative name to identify the task. You do not need to specify a unique task name. |
Source Database | Select an existing DMS database instance | The instance that you want to use. You can choose whether to use an existing instance based on your business requirements. If you select an existing instance, DTS automatically populates the parameters for the database. If you do not select an existing instance, you must configure parameters for the source database.
|
Database Type | The type of the source database. Select PolarDB (Compatible with Oracle). |
Access Method | The access method of the source database. Select Public IP Address. |
Instance Region | The region in which the source PolarDB for PostgreSQL (Compatible with Oracle) cluster resides. |
Data Sources | Single Data Source: If you select this option, you must configure the Domain Name or IP Address and Port Number parameters of the primary node in the source PolarDB for PostgreSQL (Compatible with Oracle) cluster. Multiple Data Sources: If you select this option, you must specify the IP addresses and port numbers of multiple nodes, including the primary node, in the source PolarDB for PostgreSQL (Compatible with Oracle) cluster in the IP:Port of Data Sources field. Note If you select Multiple Data Sources and configure the IP:Port of Data Sources parameter, DTS can automatically switch to a new primary node in the PolarDB for PostgreSQL (Compatible with Oracle) cluster during primary/secondary switchover. This is suitable for scenarios such as disaster recovery.
In this example, Single Data Source is selected. |
Domain Name or IP Address | The endpoint of the primary node in the source PolarDB for PostgreSQL (Compatible with Oracle) cluster. Note You can run the ping command on your computer to obtain the IP address that is used to access the source PolarDB for PostgreSQL (Compatible with Oracle) cluster. |
Port Number | The service port number of the source database. Default value: 1521. Note In this example, the service port of the source database must be accessible over the Internet. |
IP:Port of Data Sources | The IP addresses and port numbers of multiple nodes, including the primary node, in the source PolarDB for PostgreSQL (Compatible with Oracle) cluster. Specify each value in the IP address:Port number format. Separate multiple values with commas (,). |
Oracle Type | The architecture of the source database. If you select Non-RAC Instance, you must configure the SID parameter. If you select RAC or PDB Instance, you must configure the Service Name parameter.
In this example, Non-RAC Instance is selected. |
Database Name | The name of the database that contains the objects to be migrated from the source PolarDB for PostgreSQL (compatible with Oracle) cluster. |
Database Account | The database account of the source PolarDB for PostgreSQL (Compatible with Oracle) cluster. For information about the permissions that are required for the account, see the Permissions required for database accounts section of this topic. |
Database Password | The password that is used to access the database instance. |
Destination Database | Select an existing DMS database instance | The instance that you want to use. You can choose whether to use an existing instance based on your business requirements. If you select an existing instance, DTS automatically populates the parameters for the instance. If you do not select an existing instance, you must configure parameters for the destination database.
|
Database Type | The type of the destination database. Select PolarDB (Compatible with Oracle). |
Access Method | The access method of the destination database. Select Public IP Address. |
Instance Region | The region in which the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster resides. |
Data Sources | Single Data Source: If you select this option, you must configure the Domain Name or IP Address and Port Number parameters of the primary node in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Multiple Data Sources: If you select this option, you must specify the IP addresses and port numbers of multiple nodes, including the primary node, in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster in the IP:Port of Data Sources field. Note If you select Multiple Data Sources and configure the IP:Port of Data Sources parameter, DTS can automatically switch to a new primary node in the PolarDB for PostgreSQL (Compatible with Oracle) cluster during primary/secondary switchover. This is suitable for scenarios such as disaster recovery.
In this example, Single Data Source is selected. |
Domain Name or IP Address | The endpoint of the primary node in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Note You can run the ping command on your computer to obtain the IP address that is used to access the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. |
Port Number | The service port number of the destination database. Default value: 1521. |
IP:Port of Data Sources | The IP addresses and port numbers of multiple nodes, including the primary node, in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Specify each value in the IP address:Port number format. Separate multiple values with commas (,). |
Database Name | The name of the database to which objects are migrated in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. |
Database Account | The database account of the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. For information about the permissions that are required for the account, see the Permissions required for database accounts section of this topic. |
Database Password | The password that is used to access the database instance. |