Re: SQL dumps for version control

From: joel garry <>
Date: Tue, 12 Aug 2008 13:37:03 -0700 (PDT)
Message-ID: <>

On Aug 8, 1:24 am, "Álvaro G. Vicario"
<> wrote:
> I’d need to generate SQL dumps to store in a version control system. I’m
> not asking for advanced features like upgrade/downgrade scripts or the
> like. My requirements are something like this:
> - I need to store the structure of specific tables (not all); providing
> the table name should automatically backup all related objects:
> constraints, indexes, triggers, sequences…
> - I need to store the data of specific tables (not all, and not
> necessarily the previous ones).
> - Dumps should be similar when the database has not changed so diff
> tools are meaningful.
> Ideally, I’d have a script (*.bat, *.php or whatever) with two
> configuration files where I specify the table names for either case
> (e.g. structure.txt and data.txt), but it’s okay if the process has to
> be done manually.
> I’m coding a PHP web site in a Windows 2003 Server box that accesses a
> remote Oracle 10g server. I’ve installed TOAD Free and Oracle SQL
> Developer but I’m open to other tools you may suggest. The version
> control system is Subversion.
> I've tried SQL Developer's "Database Export" and the dumps look quite
> good (although it's hard to say because it puts everything in a single
> huge file) but I have to specify all the parameters every time (it
> doesn't even remember the last used directory) what looks too error prone.
> Do you have any suggestion? Thank you in advance.
> --
> -- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:
> -- Mi web de humor al baño María:
> --

There is an index of scripts on metalink Note:131704.1 (click on dba.admin, and note the one about dependency) that can be a good starting point. Be aware, some of the scripts may be old or mythbased.


-- is bogus.
"1. Initial interest as they register and explore the site's
2. Find a few friends and link up with them.
3. Don't find enough friends for the site to work as a social hub, so
the account becomes dormant." - richard.sands
Received on Tue Aug 12 2008 - 15:37:03 CDT

Original text of this message