Re: Version Control for Oracle Developer

Björn Wächter wrote:
> hpuxrac wrote:
> > Björn Wächter wrote:
> >> Hi all,
> >>
> >> I'm developing in PL/SQL. For the development I'm using database clients
> >> like Toad, Hora or SQL Developer. My problem is:
> >>
> >> - Is there a good way to get all the sql code out of the database so
> >> that it can be checked in into for example subversion. Including
> >> tables, indexes, constraints, stored procedures, sequences,
> >> packages... And I can set up a new version of my project from
> >> subversion.
> >> - In my projects I also like to put the content of tables into
> >> subversion. For example tables storing configuration data.
> >> Are there any concepts how to create insert scripts
> >> only for a few tables marked in any way.
> >>
> >> Or is there a totally different approach.
> >
> > Are you using a current version of Toad?
> >
> > All the stuff for schema objects you mention is built in already to
> > Toad. What specific problems are you having?
> >
> > You can setup data manipulation scripts as you wish to.
> >
> > What standards are in place for the company you are doing development
> > for? If there are not standards in place perhaps that is the place to
> > begin working from.
> >
>
> Perhaps I don't know how to do it with toad. I know how to generate a
> script of one object by clicking it in the schema browser and select
> "Create Script". But I'm looking for something that creates
> automatically one file for every object in the database. I also know
> of the "Generate Schema Script" in the DBA menu. But I don't want
> to check in only one file into subversion for the whole project. Any
> ideas on creating insert scripts for subversion only for some tables?
>
> Thanks for your help
> Björn

The Toad version that I have is 9.0.0.160 ( I also have the Debugger, SQL Optimizer and DBA options ).

Click on the Database Menu and the Export submenu. There's a bunch of functionality there including Generate Database script and Generate Schema script ( the schema one is probably what you want ).

You can think pick and choose what schema (s), what object types, if everything goes into 1 file per schema or 1 file per object, lots of options including filtering etc.

Not sure if these options only come with DBA module but you can always take to Quest and get a temporary key and demo what the DBA modules gives you in this area.

There's also Data related scripting, the ability to compare schemas and generate synchronization scripts, etc.

What standards are going to be in place and how will all of this be maintained is still a question that you want to consider.

We don't use Toad for these purposes where I work but it is pretty capable in these areas. It does interface with source code control systems and allows you to proceed on a project by project basis.

There's a couple of Toad yahoo message boards that many of the quest developers and serious Toad users hang out on that may be worth checking out. Received on Tue Dec 12 2006 - 08:40:15 CST