Archives of the TeradataForum
Message Posted: Wed, 19 Feb 2003 @ 20:46:56 GMT
| Subj: || || Re: Extracting DDL of a whole database |
| From: || || David Wellman |
As Michael suggestedusing ARC to move the data and tables definitions is a good start. That won't work for views or macros if they're
referring to objects in other databases or if you're goin to change the database name as part of the move.
Basically there isn't a tool which will do this (as far as I know). Best bet is to use SQL to generate all the SHOW command required to
rebuild the tables, views and macros etc.