A new topic, 'Modifying auto-generated rollback', has been made on a board you
are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=572.new#new
The text of the topic is shown below:
Hello again,
I have hundreds of foreign key constraints defined in changeSets that looks
like this:
Code:
<changeSet context="core" author="Alterian"
id="40611F0A-A0C3-F478-10CA-F2DD51B61CEC">
<addForeignKeyConstraint baseColumnNames="siteid"
baseTableName="host"
constraintName="fk_host_site_siteid" deferrable="false"
initiallyDeferred="false"
onDelete="CASCADE" referencedColumnNames="siteid"
referencedTableName="site"/>
<modifySql dbms="mssql">
<replace replace="CASCADE" with="NO ACTION"/>
<append value=" NOT FOR REPLICATION"/>
</modifySql>
</changeSet>
This works fine on the 2 databases I need to support (oracle + mssql). However,
if I need to rollback this changeSet - LiquiBase fails on mssql as it is
appending the " NOT FOR REPLICATION" option to the auto-generated DROP
CONSTRAINT sql.
I'm looking to extend the core LiquiBase to support my requirements, but am not
sure which classes to extend to cater for the addForeignKey tags.
In an ideal world, I'd like to be able to define an extension that
automatically handles my two mssql modifications (i.e. the replace and the
append) - which classes would I extend to do this?
Alternatively, how do I stop LiquiBase appending the extra text to the
auto-generated roll-back?
Thanks,
Ben
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
