RE: RE: Scripting for change with Team Coding
"Bryan, Timothy" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi Norm, When you say "DBA Option", what are you referring to? We do not have the ability to run anything against QA or Production, only dev. It is our responsibility to manage the change in Dev and then schedule a deployment along with an appropriate script to execute in QA or Production via the DBA team. What I need to be able to do is find all changes within the Dev database since a given version / revision in the repository and create a script to give the DBA's for execution to QA and later to Production. Best Regards Timothy Bryan We are what we repeatedly do. Excellence, therefore, is not an act but a habit. Aristotle -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar Sent: Monday, January 09, 2012 7:21 AM To: [email protected] Subject: Re: [toad] RE: Scripting for change with Team Coding Hi Timothy, Stephen already pointed out a lack of a scripting feature in Team Coding, however, if you have the DBA option you can do a Schema Compare between your QA database schema and your production one. The differences can be written to a script that you then run on the production schema to bring it up to the same state as the QA one. Beware of the option to "drop objects before (re)creation though! I always turn that off. :-) HTH -- Cheers, Norm. [TeamT] ------------------------------------ Yahoo! Groups Links ---------------------------------------------------------------------- Waste Management recycles enough paper every year to save 41 million trees. Please recycle any printed emails. ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/toad/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/toad/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/