RE: Controlling changes to database - Team Coding

Timothy,
If you are using Team Coding in Toad as primary means of controlling your objects, then Toad will handle the commits/check in etc in SVN.  It will  perform a lock / check out on the Team Coding Database and also in SVN.  When you do a 'check in' Team Coding does the reverse in the Database and in SVN. There should be no need to commit manually with SVN in the normal course of events. Of course there is nothing preventing your from doing this but that would put SVN out of synch with the Team Coding database, not something I would recommend :)

Stephen

From: [email protected] [mailto:[email protected]] On Behalf Of Bryan, Timothy
Sent: Wednesday, January 11, 2012 12:39 PM
To: [email protected]
Subject: RE: [toad] Controlling changes to database - Team Coding



This process would keep the objects updated in the svn repository and once run in the database it would update there as well. The last question now then is the check-in / check-out within TOAD. If I just open the file in my local repository, with subversion it is marked as changed and needs update. I can use my svn client to just right click and do a SVN commit. How does the check-out in TOAD need to be used? Will it do the check-out only in subversion? If I use the schema browser and check a file out from the Team Coding menu, is it not checked out in subversion and updated in the local repository where then a subsequent Check-in would be needed?

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]<mailto:toad%40dunbar-it.co.uk>]
Sent: Wednesday, January 11, 2012 11:15 AM
To: Bryan, Timothy
Subject: Re: [toad] Controlling changes to database - Team Coding

Hi Timothy,

> 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.
No, I got it twice, maybe your spam filter trapped it first time?

> How do you open the local files in TOAD typically if you need to update some object?
In the normal way - I click on the dropdown button or on the file open button on the toolbar, navigate to and select the file(s) I want.

> 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.
Yes indeed. Although I have the objects in the database, because I have
the option that allows me to compile directly inside the database turned
off, I must load a script into the editor to be able to compile the object.

So, I load the file for the object in question, edit it, compile, repeat
as necessary and eventually, save it.

It's second nature to my way of working (now!) but it means that I keep
a full record of changes that I've made to any of the objects within the
database.

Also, does this keep the Team Coding piece in synch with the repository?
Because the working files are edited and saved, Subversion flags them up
as modified and I commit them to the repository as and when. Other
DBA/Developers in the team can then run an svn update to pick up my
changes - either when they next want to edit them, or they will be
forced to update next time they try to commit their own changes.

So, working in this way, keep the repository up to date with the database.

I never used to have that setting configured, but I once edited and
compiled an object and "lost" track of the changes. Luckily it was my
own system and I don't share those scripts with others, so I was able to
chastise myself - and then I made sure that the option was set to
prevent me messing up again!

> Sorry for so many newbie questions, but really need to fix our sloppy control process.
Fear not, we all start somewhere. We don;t mind questions of any kind on
this list - ask away, if I can't help, someone else will.

--
Cheers,
Norm. [TeamT]

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