Recently, I was presented with a situation to move several Terabytes of data from one machine to another. So FastExport/FastLoad really wasn’t feasible. I didn’t have the hard drive space to hold the flat files because they were so big. So then I tried to archive the database, but again, the archive file was too big. So digging a little deeper, I found that you can move a database from one machine to another using a named pipe archive. This allows an archive of one database and a restore onto another at the same time and the archive file only fills up to a buffer, so it doesn’t get very big. I am not a Linux guru, but I was able to get this done pretty quickly.
What you will need before embarking on this path. Logon credentials to one of the Linux machines or a Linux machine with ARCMAIN installed having network access to both Teradata Databases. Either the source database machine or destination, I don’t think it matters. Logon credentials to both the Source Database and Destination Database and the Database Sizes of the Source Data. You can get this information from Teradata Administrator. In Teradata Administrator “right click” on a database/user and select the option that best gives you the information you are looking for for what you intend to copy.
That’s it, pretty simple even for a windows guy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.