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.
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).