Data Protction (Near Real DR setup) Triggers and Shadow Tables

General

Data Protction (Near Real DR setup) Triggers and Shadow Tables

HI ALL ,

We are plaining to impliment near real time DR setup , we have two teradata system .
Production 6 Node and DR 2 node.
Here is what I am thinking :-

Create a trigger , when ever any tables get "INSERT,UPDATE OR DELETE " Operation on it , trigger should be
generated and it should create SHADOW tables for the same tables , which has only "INSERT,UPDATE OR DELETE "
data in it , which can be easly FEXP or FLOAD to DR system.

Can any one has any idea about it , or implited any such solution to create near real time DR ,
If any one has any idea , please shear here , will be great help.

Thanks

DG
1 REPLY
Teradata Employee

Re: Data Protction (Near Real DR setup) Triggers and Shadow Tables

DG, you should look into Teradata Multisystem Manager & DataMover combo. These products can provide you near real data replication and will ensure data synchronization.

Implementing this from scratch is no easy task!!