InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:43:42 GMT20http://www.teradata.com/teradataforum/Topic11860-9-1.aspxWe always use TPT (previoulsly known as TWB) to move data between databases.Fri, 11 Jul 2008 18:51:08 GMTsyed_tdhttp://www.teradata.com/teradataforum/Topic11860-9-1.aspxdepending on volume and network you could also use OLE-load.Fri, 11 Jul 2008 10:58:39 GMTtanova535http://www.teradata.com/teradataforum/Topic11860-9-1.aspxWe 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.Fri, 11 Jul 2008 04:27:31 GMTdhirajpalsehttp://www.teradata.com/teradataforum/Topic11860-9-1.aspxAtanasoft has some interesting tools do do that very thing. RThu, 10 Jul 2008 11:11:25 GMTRon Luebkehttp://www.teradata.com/teradataforum/Topic11860-9-1.aspxIf your table is smaill you can even do a bteq export/importTue, 17 Jun 2008 02:54:05 GMTBharathhttp://www.teradata.com/teradataforum/Topic11860-9-1.aspxyou have to either archive and copy. Or fastexport/fastloadFri, 13 Jun 2008 18:12:17 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11860-9-1.aspxI 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.tblMnoHow do I do it? Thanks.Fri, 13 Jun 2008 17:33:28 GMTmfarid