Re: SQL dumps for version control
Date: Tue, 12 Aug 2008 13:37:03 -0700 (PDT)
On Aug 8, 1:24 am, "Álvaro G. Vicario"
> 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.
> --http://alvaro.es- Álvaro G. Vicario - Burgos, Spain
> -- Mi sitio sobre programación web:http://bits.demogracia.com
> -- Mi web de humor al baño María:http://www.demogracia.com
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.
-- @home.com is bogus. "1. Initial interest as they register and explore the site's capabilities. 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.sandsReceived on Tue Aug 12 2008 - 15:37:03 CDT