DdlUtils
  1. DdlUtils
  2. DDLUTILS-101

Support the dumping of data from a database into an XML file for each table.

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.3
    • Component/s: Ant Tasks
    • Labels:
      None
    • Environment:
      WinXP
      Java 1.5.0_06
      Oracle 10g EE

      Description

      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.

        Activity

        Guy Davis created issue -
        Guy Davis made changes -
        Field Original Value New Value
        Attachment multi_files.patch [ 12325586 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.1 [ 12311984 ]
        Thomas Dudziak made changes -
        Component/s Ant Tasks [ 12310805 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.1 [ 12311984 ]
        Fix Version/s 1.3 [ 12313497 ]

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Guy Davis
          • Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development