db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guy Davis (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DDLUTILS-101) Support the dumping of data from a database into an XML file for each table.
Date Thu, 20 Apr 2006 02:38:34 GMT
     [ http://issues.apache.org/jira/browse/DDLUTILS-101?page=all ]

Guy Davis updated DDLUTILS-101:

    Attachment: multi_files.patch

This includes two new Commands that allow for the dumping of a database to multiple XML files
(one per table) and the loading of data from multiple files.  The loading is done similarly
as if all the files were in one large XML file, which allows for reference between the tables
involved in the load.  (This wasn't supported by the existing WriteDataToDatabase command.

The dump adds an ORDER BY to the SELECT * FROM TABLE_NAME consisting of primary keys.  This
means the dump is consisent every time and one can diff the dump files between data changes
in a human readable format.

> Support the dumping of data from a database into an XML file for each table.
> ----------------------------------------------------------------------------
>          Key: DDLUTILS-101
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-101
>      Project: DdlUtils
>         Type: Improvement

>  Environment: WinXP
> Java 1.5.0_06
> Oracle 10g EE
>     Reporter: Guy Davis
>     Assignee: Thomas Dudziak
>  Attachments: multi_files.patch
> We're using DDLUtils to store the schema and setup data required for our application.
 We can version the XML files and see diffs of the schema and data after dumping a modified
database.  This is a great feature.
> However the single XML file containing all the setup data from our ~25 tables grew to
over 3 MB in size and was unwieldy to work with.  In particular, a simple "select * from table"
was used to dump the data.  This would result in spurious diffs where the file contents didn't
change between dumps but the lines were moved around making a diff unreadable.
> So it would be great if the Ant tasks supported dumping a database to a directory with
 one XML for each tables data.  Also, the dump should be ordered by the tables primary keys
so that it is possible to easily compare with older versions and see new rows, deleted rows,
and changed fields.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message