|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/13/2008 5:28:37 PM
Posts: 1,
Visits: 4
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425,
Visits: 398
|
|
|
you have to either archive and copy. Or fastexport/fastload
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/26/2008 1:20:52 AM
Posts: 4,
Visits: 8
|
|
|
If your table is smaill you can even do a bteq export/import
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 8/27/2008 1:28:16 PM
Posts: 28,
Visits: 25
|
|
Atanasoft has some interesting tools do do that very thing.
R
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/4/2008 6:57:31 AM
Posts: 28,
Visits: 153
|
|
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.
Dhiraj P
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/11/2008 10:57:48 AM
Posts: 7,
Visits: 9
|
|
|
depending on volume and network you could also use OLE-load.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/25/2008 7:46:52 PM
Posts: 8,
Visits: 13
|
|
|
We always use TPT (previoulsly known as TWB) to move data between databases.
|
|
|
|