[ http://issues.apache.org/jira/browse/DDLUTILS-101?page=all ]
Thomas Dudziak updated DDLUTILS-101: ------------------------------------ Fix Version: 1.1 > 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 > Fix For: 1.1 > 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: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira