RE: Controlling changes to database - Team Coding

Hi Norm,

I guess I have to pay better attention to how I reply as my question did not go to the list; must have gone out to you only.  I may repost it so it goes out.

The information you provided is very helpful and what I was looking for.  I do have a couple of questions.  When you indicate you are working on the files in your local repository, we do this too with our C sharp repository, but the local files (solution) is opened in Visual Studio this way by default.  This makes it easy to open the solution, edit the files, then check in.  With TOAD it is not so cut and dry.  Most of our developers are accustomed to opening the schema browser then double clicking on an object to open it in the editor.  Now we need to do a check out, but this may not be keeping our svn repository up to date.

How do you open the local files in TOAD typically if you need to update some object?  I realize, I can open a file in TOAD, but I use the schema browser to locate what I am looking for, say a package and then can see the script.  It would seem then, we need to open that file from the local repository to edit this.  Also, does this keep the Team Coding piece in synch with the repository?

Sorry for so many newbie questions, but really need to fix our sloppy control process. 

Best Regards

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


-----Original Message-----
From: Norman Dunbar [mailto:[email protected]] 
Sent: Wednesday, January 11, 2012 8:57 AM
To: Bryan, Timothy
Subject: Re: [toad] Controlling changes to database - Team Coding

Hi Timothy,

> We are very new to Team Coding so just trying to learn the do's and don'ts.

Here's what I do, which may or may not help.

I have Toad configured so that I cannot compile anything that was loaded from the database - as previously mentioned.

I have a Subversion repository on a remote server.

I work on my code on my desktop in a folder that I checked out from Subversion.

So, I work away with everything that I need to, using Toad but only working on files I've loaded from my local folder. Any changes I make get saved back and when all is compiled and happily tested, I switch out of Toad and into Explorer where I use TortoiseSVN to commit all the files that I changed, in one transaction, back to the repository.

Older versions of Toad allowed only one file to be checked in. I think Stephen made some changes in 11 to allow all affected files (or all open tabs perhaps - I forget!) to be committed as one transaction.

I've only just got Toad 11, and I've not been able to use it in anger yet as my work changed recently and my new contract doesn't require a lot of Toad work. :-(

Anyway, I commit all the affected files in one go and I can see what changed in each of those files using TortoiseSVN to diff the previous version with the latest and so on.

It's not ideal because Subversion can't give you the script you need to bring a table, for example, up to date - it can give you a patch file that can be applied to the previous script (to create the table) to bring it up to date. However, in production you already have the table and all you ned is something like an ALTER TABLE command. It's not possible to get that from Subversion, unless, as part of the development process, you create one and check it in to Subversion.

It's better with creating patches for stored code, functions and packages as they tend to start with CREATE OR REPLACE ... whereas a CREATE OR REPLACE TABLE doesn't exist.

So, Subversion on it's own can't give you all that you need to bring a database up to date but it can help. Toad, on the other hand can create a script to do exactly that - but you need access to the production/QA database as well as the development one and you need the DBA module to actually be able to edit or save the generated script.


HTH


--
Cheers,
Norm. [TeamT]

----------------------------------------------------------------------
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/