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
Assigned to: Thomas Dudziak
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:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
