A new topic, 'MSSQL 2k5 - convert old style on Delete triggers to onDelete at constraint level', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=155.new#newThe text of the topic is shown below:
As mentioned in my previous post the legacy way of managing onDelete in SQL Server was at the table level of the foreign table.
Fortunately, 2k5 supports the ON DELETE syntax that the rest of the SQL world has also adopted.
Unfortunately, we have a lot of FK constraints whose onDelete triggers are still managed at the table level of the foreign table. Was wondering if anyone in his community has written a custom liquibase change set that goes through and converts these old style triggers into FK constraints with the onDelete attached to the actual constraint.
Liquibase seems to only use this system for handling onDelete, so by introducing Liquibase we're going to have a mix of both systems until we figure out how to convert them.
The biggest problem with this is that if we use Liquibase change or manipulate an existing foreign key column or table containing a fk column, we have to consult the referenced table and update any of these old style ON DELETE triggers by hand making the use of Liquibase very cumbersome and not very vendor agnostic.
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user
