Move data from one Teradata DB(Prod Server)to another Teradata DB (dev Server)

Database
Enthusiast

Move data from one Teradata DB(Prod Server)to another Teradata DB (dev Server)

Hi Team,

i have a requirement, that i need to move data from one teradata DB to another Teradata DB, Difficutly is I need to move around 40 tables daily, is there any process that it can be done automatically, so that it can reduce manual effort.

Can we move data of multiple tables  at a time.... for example in datamover.. we will be giving a single table ... can we have any chance to give 40 tables to move data from source to target

ex:

Prod database          dev database

a.table -------------->  a.table

b.table --------------> b.table

c.table --------------> c.table

so on... (for 40 table

Tags (1)
1 REPLY
Teradata Employee

Re: Move data from one Teradata DB(Prod Server)to another Teradata DB (dev Server)

Hello Kartaj,

DM can moves 40 tables in a single DM Job {It can move multiple databases in 01 Job as well}. You just need to create the DM Job once & run it as per your requirement. Depending on your use-case, you can use ARC or TPT API. These details are available @ DataMover User Guide from Teradata Info website.

Thanks, Smarak