This topic describes how to migrate data from a self-managed PostgreSQL database to a PolarDB for Oracle cluster by using Data Transmission Service (DTS).
Prerequisites
- The destination PolarDB for Oracle cluster is created. For more information, see Create a cluster.
- The available storage space of the destination PolarDB for Oracle cluster is larger than the total size of the data in the self-managed PostgreSQL database.
Limits
Category | Description |
---|---|
Limits on the source database |
|
Other limits |
|
Billing
Migration type | Task configuration fee | Internet traffic fee |
---|---|---|
Full data migration | Free of charge. | Charged only when data is migrated from Alibaba Cloud over the Internet. For more information, see Pricing. |
Incremental data migration | Charged. For more information, see Pricing. |
Migration types
- Full data migration
DTS migrates historical data of required objects from the source database to the destination database.
- Incremental data migration
After full data migration is completed, DTS migrates incremental data from the source database to the destination database. Incremental data migration ensures service continuity when you migrate data between self-managed databases.
SQL operations that can be migrated
Operation type | SQL statements |
---|---|
DML | INSERT, UPDATE, and DELETE |
Permissions required for database accounts
Database | Schema migration | Full data migration | Incremental data migration |
---|---|---|---|
Self-managed PostgreSQL database | The USAGE permission on pg_catalog | The SELECT permission on the objects to be migrated | The permissions of the superuser role |
PolarDB for Oracle cluster | The permissions of the database owner
Notice You can specify the database owner when you create a database.
|
For more information about how to create and authorize a database account, see the following topics:
- Self-managed PostgreSQL database: CREATE USER and GRANT
- PolarDB for Oracle cluster: Create an account