Archives of the TeradataForum

Message Posted: Wed, 19 Feb 2003 @ 20:46:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Dave

	<Prev	Next>		<<First	<Prev	Next>	Last>>