This topic describes how to synchronize data from a Teradata database to an AnalyticDB for PostgreSQL instance by using Data Transmission Service (DTS).
Prerequisites
- You can configure a data migration task for this scenario only in the DTS console of the new version.
- The version of the Teradata database is 17.
- The destination AnalyticDB for PostgreSQL instance is created. For more information, see Create an AnalyticDB for PostgreSQL instance.
- The available storage space of the destination AnalyticDB for PostgreSQL instance is larger than the total size of the data in the Teradata database.
Limits
Billing
Migration type | Task configuration fee | Internet traffic fee |
---|---|---|
Schema migration and full data migration | Free of charge. | Charged only when data is migrated from Alibaba Cloud over the Internet. For more information, see Pricing. |
Migration types
- Schema migration
DTS migrates the schemas of required objects from the source database to the destination database.
Warning Teradata and AnalyticDB for PostgreSQL are heterogeneous databases. Their data types do not have one-to-one correspondence. We recommend that you evaluate the impact of data type conversion on your business. For more information, see Data type mappings between heterogeneous databases. - Full data migration
DTS migrates historical data of required objects from the source database to the destination database.
Permissions required for database accounts
Database | Schema migration | Full data migration |
---|---|---|
Teradata database | The read permissions on the objects to be migrated | |
AnalyticDB for PostgreSQL instance | The read and write permissions on the destination database |
- Self-managed Teradata database: Adding Permissions
- AnalyticDB for PostgreSQL instance: Create a database account and Manage users and permissions