Moving data between 2 servers in Teradata

Database
N/A

Moving data between 2 servers in Teradata

I would like to move data between 2 servers and databases in Teradata. Let's say, I have server svrABC_123 and database dbXyz and table tblPqr. I have another server svrDEF_456 which has database dbKlm which has table tblMno. I would like to move data from:

svrABC_123.dbXyz.tblPqr
TO
svrDEF_456.dbKlm.tblMno

How do I do it? Thanks.

8 REPLIES
Enthusiast

Re: Moving data between 2 servers in Teradata

you have to either archive and copy. Or fastexport/fastload
Enthusiast

Re: Moving data between 2 servers in Teradata

If your table is smaill you can even do a bteq export/import
Enthusiast

Re: Moving data between 2 servers in Teradata

Atanasoft has some interesting tools do do that very thing.

R
Enthusiast

Re: Moving data between 2 servers in Teradata

We can make use of TPT in this case if at all installed.
Then we dont need to create an intermediate physical file like in FastExport or Bteq Export.
Enthusiast

Re: Moving data between 2 servers in Teradata

depending on volume and network you could also use OLE-load.
Enthusiast

Re: Moving data between 2 servers in Teradata

We always use TPT (previoulsly known as TWB) to move data between databases.
Teradata Employee

Re: Moving data between 2 servers in Teradata

In TD Administrator by left side is icon Copy objects. You will connect from same TDA the other DB, create same db there and copy objects. Sometime helpfull for creating copy of objects. But this objects are created empty and after that can be filled easily with OLELoad - hepfull that you don't need manualy create basic objects as tables.

Enthusiast

Re: Moving data between 2 servers in Teradata

Thanks jk186010, it worked.

Can I do the same through SQL Assistant or BTEQ?

Thanks,

Dinesh