[ 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.