RE: Source Control for DB objects

>> In particular, I'd also be curious what
>> development tools you use (Oracle's SQL Developer? Toad?)
Toad.
SQL*Plus.
TortoiseSVN.
Subversion command line utilities.

I tried SQL Developer, I just don't like it. But then again, I've been a Toad fan for a good many years now. Since before Quest owned it.

>> and if your tools integrate with your source control system
>> for PL/SQL scripts.

Toad does, with Subversion plus a few others. I do have a problem with Toad's current (due for a refit soon!) implementation of source control using Subversion. When I have say 10 files open in the editor to fix one particular bug, then I have to check them all back in, via Toad, one at a time.

The whole point of Subversion is to check all 10 files in together as one commit.

A forthcoming version of Toad 11, I think, will allow this feature. In the meantime, I save all the files to a working folder and do the commit separately using TortoiseSVN. (Which Toad can interface with by the way.)

>> I'd also be curious to hear what you
>> put into change control - just PL/SQL code, or also system
>> configuration/schema updates? How about shell scripts?
Just about everything I do to be honest:

PL/SQL
SQL scripts
Bash scripts
PHP scripts
Windows command files.
Text files (non script)
PDF files.
XML files.
C source.
C++ source.
68000 Assembly Source (Not Oracle related obviously!) Etc....

As I move from job to job, I take my scripts with me. They evolve. Keeping everything in a repository is great as I can dump the repository when I move on, and keep the latest versions (actually, entire history) with me.

I also run quite a few Subversion repositories on a USB stick.

Cheers,
Norm.

Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Team (EA)
Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

--
http://www.freelists.org/webpage/oracle-l