All Forums Database
sfhall 5 posts Joined 11/12
09 Nov 2012
Oracle Replay feature in Teradata?

Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?
Kind regards,
Steven

CarlosAL 512 posts Joined 04/08
12 Nov 2012

Steven:
You may take a look at Teradata System Emulation Tool.
HTH.
Cheers.
Carlos.

sfhall 5 posts Joined 11/12
13 Nov 2012

Thanks Carlos I will do.
 
Steven

sfhall 5 posts Joined 11/12
15 Nov 2012

I can see that the tool has a degree of control over connectivity but is it possible to schedule and monitor SET exports/imports from the command line?
Also how long would it take to complete a SET export/import a 100TB database - days/hours/minutes?
 
Kind regards,
Steven

CarlosAL 512 posts Joined 04/08
16 Nov 2012

Steven:
If you want to move big volumes between systems, you could try Datamover or you could write your own processes. The time will vary depending on many factors (hardware, communications, etc...)
HTH.
Cheers.
Carlos.

You must sign in to leave a comment.