Data migration between 2 different Boxes

Database
Fan

Data migration between 2 different Boxes

Hello!

Our team is working in migrating data of few databases from one server to another server which are in different locations. Possibality of data movement  through only physical data dump due to some org policies.  

we have Teradata 14

We like to understand is there any way to take DB backup and move to new server and restore DB?

is ther any challenges in restoring data which get dumped to  CSV/txt  files?

if any one gone through simillar activity, what are all the learnings.

Tags (1)
2 REPLIES
Junior Supporter

Re: Data migration between 2 different Boxes

Hi.

arcmain dump + arcmain restore / copy should work, but you must take care of things such as if the systems are same version, number of AMPs, etc...

You should review the documentation before starting the process (Teradata Archive/Recovery Utility Reference).

HTH

Cheers.

Carlos.

Fan

Re: Data migration between 2 different Boxes

Thanks Carlos,

Teradata Versions are smillar, but Number of AMP's are not same.