How to create Database dumps in teradata

Tools
Enthusiast

How to create Database dumps in teradata

Hi All,

I need to create a copy of Database into a newly created database. My old data base has around 200 elements comprising of macros, stored procedures and tables/ views. Is there any teradata utility available to do it. As it will take a long time to copy each individual element.
It's an urgent requirement.

Thanks in advance
1 REPLY
JvR
Enthusiast

Re: How to create Database dumps in teradata

I can think of two ways;

1. Have a look at ARCMAIN. You can find it in the manual in the chapter Teradata Archive/Recovery Utility.

2. Use a query to export the DDL of objects and run it on the new machine. After that, use ARCMAIN to export/import the data.

Good luck,

Jos van Raamsdonk.