Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 02 Feb 2007 @ 23:09:30 GMT


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


Subj:   Re: How to dump all object definitions in a database
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, February 02, 2007 17:18 -->

Kaare,

Not sure why TSET was not considered. May be you wish to run this in the scheduled setting. If so, script to generate show and run the show script was the best option. Show <objects> should not have take a long time.

Anyway, if you select a whole database when you export from TSET then select only DDL then you have what you want or just pick the output file with ddl extension then you have it.

As DBA, I have done this frequently before and after an upgrade or new installation of any kind.


Hope this helps.



     
  <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: 28 Jun 2020