Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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.

Dave



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016