You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Guy Davis (JIRA)" <ji...@apache.org> on 2006/02/22 04:14:13 UTC

[jira] Created: (DDLUTILS-76) Ability to merge two different schema XMLs and output the upgrade scripts in SQL for target 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
 Environment: Oracle 10g EE, SQL Server 2005 EE, MySQL 5.0
Java 1.5.0
Windows XP
Ant 1.6.5
    Reporter: Guy Davis
 Assigned to: 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

[jira] Updated: (DDLUTILS-76) Ability to merge two different schema XMLs and output the upgrade scripts in SQL for target database

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ 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

[jira] Updated: (DDLUTILS-76) Ability to merge two different schema XMLs and output the upgrade scripts in SQL for target database

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ 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.