Synchronizing Initial Data Across Teradata Databases

Teradata Unity Installation, Configuration, and Upgrade Guide for Customers

brand
Analytical Ecosystem
prodname
Teradata Unity
vrm_release
16.00
category
Administration
Configuration
Installation
featnum
B035-2523-037K

Synchronization includes databases, tables, views, Stored Procedures, Macros and User Defined Functions.

You can use any of the following methods to synchronize data across Teradata Databases.

Goal Description Method
Synchronize the data In a standard setup, initially synchronize the data using any method.

Teradata Archive/Recovery Utility (ARC)

Teradata Data Mover

Teradata Replication Services
If Teradata Replication Services is used to perform the initial data synchronization, it must be disabled once Unity is used to manage the data synchronization.
Create a production backup system In a situation where Unity manages production and Disaster Recovery (DR) systems, the DR system typically has the exact same data as the production system. After the restore completes, both systems have the same data. Restore a full backup of the production system to the DR system while the production system is offline.
Synchronize individual tables If a full backup/restore cannot be done or not all tables are replicated across all systems (systems do not have identical data), you can synchronize the tables individually. Perform a table copy with Teradata Data Mover while the source tables are offline.
After synchronization, the SYSTEM ACTIVATE ALL command in the UnityAdmin tool is available.