[ http://issues.apache.org/jira/browse/DDLUTILS-76?page=all ]
Thomas Dudziak updated DDLUTILS-76:
-----------------------------------
Component: Ant Tasks
Core (No specific database)
> Ability to merge two different schema XMLs and output the upgrade scripts in
> SQL for target database
> ----------------------------------------------------------------------------------------------------
>
> Key: DDLUTILS-76
> URL: http://issues.apache.org/jira/browse/DDLUTILS-76
> Project: DdlUtils
> Type: New Feature
> Components: Core (No specific database), Ant Tasks
> 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
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
