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

Reply via email to