Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!fu-berlin.de!uni-berlin.de!news.dfncis.de!not-for-mail
From: =?ISO-8859-1?Q?Bj=F6rn_W=E4chter?= <bwc@p3-solutionsKILL_SPAM.de>
Newsgroups: comp.databases.oracle.server
Subject: Version Control for Oracle Developer
Date: Tue, 12 Dec 2006 12:06:49 +0100
Lines: 18
Message-ID: <4u7gqaF16qpq3U1@mid.dfncis.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.dfncis.de dBwEiLzkm1jcg4ZGthm2XQd4rIyxmLGjoqQCtmERSOqQQfHV/5VClZhebJ
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
Xref: usenetserver.com comp.databases.oracle.server:418978
X-Received-Date: Tue, 12 Dec 2006 06:06:51 EST (text.usenetserver.com)

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.

Thanks Björn