Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2011 @ 07:46:34 GMT


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


Subj:   Re: Capture output from "show select *" into a table
 
From:   Curley, David

Here's a similar earlier thread:

www.teradataforum.com/teradata/20070810_164431.htm


We have something like Frank Martinez' grant query that we use to push changes to production. It generates a complete script with object DDL, grants and stats to collect based on what's actually in the development environment. Database references then get turned into generic tags which are automagically replaced with production database names when the creation script is run on that side. We also use the resulting ddl scripts with a change control system. (And since a developer could check out one of these files, modify it and check it in w/o changing the database, we have another variation that dumps out SHOW results for our entire production database and runs those against a sepearate change control repository so we can track actual day-over-day changes.)


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: 15 Jun 2023