[
https://issues.apache.org/jira/browse/DDLUTILS-76?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Dudziak updated DDLUTILS-76:
-----------------------------------
Fix Version/s: 1.2
> Ability to merge two different schema XMLs and output the upgrade scripts in
> SQL for target database
> ----------------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-76
> URL: https://issues.apache.org/jira/browse/DDLUTILS-76
> Project: DdlUtils
> Issue Type: New Feature
> Components: Ant Tasks, Core (No specific database)
> Environment: Oracle 10g EE, SQL Server 2005 EE, MySQL 5.0
> Java 1.5.0
> Windows XP
> Ant 1.6.5
> Reporter: Guy Davis
> Assignee: Thomas Dudziak
> Fix For: 1.2
>
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
