Re: Version Control for Oracle Developer

From: Björn Wächter <bwc_at_p3-solutionsKILL_SPAM.de>
Date: Tue, 12 Dec 2006 15:22:56 +0100
Message-ID: <4u7sa1F16moonU1@mid.dfncis.de>

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 Received on Tue Dec 12 2006 - 08:22:56 CST