RE: Scripting for change with Team Coding

Hi Timothy,
I would like to hear some other Team Coding users chime in with a response to your first question, I can't speak to what a typical way might look like :)
Team coding will help prevent developers over writing each other, as you suggest.  You can create your script manually, as Norm suggests.

A scripting Tool from Team Coding sounds like an good idea for the Toad Pond.

Stephen


From: [email protected] [mailto:[email protected]] On Behalf Of Bryan, Timothy
Sent: Monday, January 09, 2012 8:33 AM
To: [email protected]
Subject: [toad] RE: Scripting for change with Team Coding


Stephen,

Thanks for the reply.  What is the typical way development teams keep track of the changes in order to promote them to QA or then to Production?  We enabled Team Coding and integration with Subversion to protect us against the many forgotten changes that do not make it to QA resulting in secondary deployments to fix it.  Occasionally they do not make it to production either.  With Team Coding, we should no longer see one developer script over writing another because they changed the same thing, however that will only be valid if we have a way to create our script automatically or manually based on changed objects in the database schema.

Best Regards

Timothy Bryan
We are what we repeatedly do.  Excellence, therefore, is not an act but a habit.
Aristotle

From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Beausang
Sent: Monday, January 09, 2012 6:50 AM
To: [email protected]
Subject: [toad] RE: Scripting for change with Team Coding


Hello,
Team Coding does not have a specific function to do this. But you might want to check out the Schema Browser 'Create Script ' option and also Database Export options which may be able to accomplish what you need.

Stephen


From: [email protected] [mailto:[email protected]] On Behalf Of Bryan, Timothy
Sent: Friday, January 06, 2012 11:31 AM
To: [email protected]
Subject: [toad] Scripting for change with Team Coding


We are using an Oracle 10g database with TOAD 11 and Team Coding installed along with Subversion.  Currently, we have three developers who make changes to database objects and now must check out / in those objects.  When it comes time to release these changes to QA or production, what is the best way to find the changes so a script can be prepared?  Are there any built in tools for scripting all the changes?

Best Regards

Timothy Bryan
We are what we repeatedly do.  Excellence, therefore, is not an act but a habbit.
Aristotle

________________________________

Waste Management recycles enough paper every year to save 41 million trees. Please recycle any printed emails.