Data Mover 16.00 and later supports copying tables between Teradata to Teradata databases using the QueryGrid T2T utility.
Restrictions
- The following data types are not supported by T2T:
- BLOB, CLOB, PERIOD, JSON, UDT Based Transfer Protocol (for example, XML), and Geospatial.
- By default, Data Mover allows five concurrent T2T tasks running on one system. This applies to both the source and target systems. This value can be modified using the configuration.xml file; however, allowing too many T2T tasks to run at the same time causes source and system resource issues.
- The load_from_td and load_to_td connection allows a maximum of 2048 table columns to transfer, row size must be less than 64 k.
- Transaction semantics are not supported between systems using T2T.
- The target system name must match the foreign server remotehost properties, if not, a validation error occurs.
- The foreign server local_ips must be designated as the source system ips or source system host name.
Known Issues
- A T2T job cannot be stopped while in the middle of performing a task. Tasks run until they are completed and cleanup will not kill these tasks. If more than 20 T2T tasks are running concurrently on the same system, including T2T queries not initiated by Data Mover, system resources will be affected.
- Data Mover does not report T2T job progress.