Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!73g2000cwn.googlegroups.com!not-for-mail
From: "hpuxrac" <johnbhurley@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Version Control for Oracle Developer
Date: 12 Dec 2006 04:53:36 -0800
Organization: http://groups.google.com
Lines: 30
Message-ID: <1165928015.970010.119800@73g2000cwn.googlegroups.com>
References: <4u7gqaF16qpq3U1@mid.dfncis.de>
NNTP-Posting-Host: 208.44.49.5
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1165928021 32615 127.0.0.1 (12 Dec 2006 12:53:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 12:53:41 +0000 (UTC)
In-Reply-To: <4u7gqaF16qpq3U1@mid.dfncis.de>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 PROXY
Complaints-To: groups-abuse@google.com
Injection-Info: 73g2000cwn.googlegroups.com; posting-host=208.44.49.5;
   posting-account=Dz_3bQ0AAAC5LZNB2NPEJz1sl_a8qcDY
Xref: usenetserver.com comp.databases.oracle.server:418990
X-Received-Date: Tue, 12 Dec 2006 07:53:41 EST (text.usenetserver.com)


Bj=F6rn W=E4chter 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.