RE: Source Control for DB objects

  • From: "Dunbar, Norman (Capgemini)" <norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: <jeremy.schneider@xxxxxxxxxxxxxx>, <Joel.Patterson@xxxxxxxxxxx>
  • Date: Thu, 4 Aug 2011 16:32:34 +0100

Hi Jeremy,

>> In particular, I'd also be curious what 
>> development tools you use (Oracle's SQL Developer? Toad?) 
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

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

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!)

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.


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 

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

Other related posts: