[ http://issues.apache.org/jira/browse/DDLUTILS-89?page=all ]
Thomas Dudziak resolved DDLUTILS-89.
------------------------------------
Resolution: Fixed
The platform interface has a new property foreignKeysSorted, and the two tasks
(DatabaseToDdl, DdlToDatabase) have a related sortForeignKeys attribute, which
- when set to true - force the alphabetical sorting of the foreign keys of the
tables read from the database. Note that this does not affect the foreign keys
of tables read from an XML file.
> Add support for ordering of foreign keys when reading from a live database
> --------------------------------------------------------------------------
>
> Key: DDLUTILS-89
> URL: http://issues.apache.org/jira/browse/DDLUTILS-89
> Project: DdlUtils
> Issue Type: Improvement
> Components: Core (No specific database), Ant Tasks
> Environment: Oracle 10g EE
> SQLServer 2005 EE
> Windows XP SP2
> Java 1.5.0_06
> Reporter: Guy Davis
> Assigned To: Thomas Dudziak
> Fix For: 1.0
>
> Attachments: order_fks.patch
>
>
> We use the WriteSchemaToFile task to store our applications schema in a file
> we place in our Subversion CM tool. Every time we run this task, it reorders
> the foreign keys on a table. So, for example, if Table A has FKs X, Y, Z
> then schema.xml file alternates between:
> <table ...>
> <fk name='X' .../>
> <fk name='Y' .../>
> <fk name='Z' .../>
> </table>
> AND
> <table ...>
> <fk name='Z' .../>
> <fk name='Y' .../>
> <fk name='X' .../>
> </table>
> Notice, that the keys haven't changed between schema dumps, just the ordering
> of them in the file. This means tracking version changes is more complicated
> as a developer's real changes are mixed in with these spurious key position
> changes.
--
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
