DdlUtils
  1. DdlUtils
  2. DDLUTILS-76

Ability to merge two different schema XMLs and output the upgrade scripts in SQL for target database

    Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 1.3
    • Labels:
      None
    • Environment:
      Oracle 10g EE, SQL Server 2005 EE, MySQL 5.0
      Java 1.5.0
      Windows XP
      Ant 1.6.5

      Description

      It would be great if DDLUtils had the ability to diff two schema XML files (source and target) and generate database-specific SQL that can be saved to a file? Ideally, I'd like to use for handling database upgrades of our product. The SQL output would be all the "alter table" type statements required to move from the source schema to the target.

      This seems to be almost what the WriteSchemaToDatabase command is doing for a single schema and a live database with alterDatabase=true. Could we replace the live database with a second schema and then have the SQL sent to a file rather than to the live database.

        Activity

        Guy Davis created issue -
        Thomas Dudziak made changes -
        Field Original Value New Value
        Component/s Core (No specific database) [ 12310804 ]
        Component/s Ant Tasks [ 12310805 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.2 [ 12312767 ]
        Thomas Dudziak made changes -
        Fix Version/s 1.2 [ 12312767 ]
        Fix Version/s 1.3 [ 12313497 ]

          People

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

            Dates

            • Created:
              Updated:

              Development