InstantForum.NET v4.1.4StrataFrame Forumhttp://forum.strataframe.net/forum@strataframe.netThu, 08 Jan 2009 08:11:47 GMT20http://forum.strataframe.net/Topic4911-13-1.aspxAha... thanks for the report... I'll change the DatabaseMigrator to do just that when altering foreign keys. Thanks.Mon, 04 Dec 2006 13:45:30 GMTBen Chasehttp://forum.strataframe.net/Topic4911-13-1.aspxTo repro:</P><P>Define a FK relationship.</P><P>Deploy the database.</P><P>Change the cascade behavior of the FK relationship.</P><P>Deploy the database. SQL Server complains that you can't Alter--you must drop and recreate with the desired cascade behavior.</P><P>Workaround:</P><P>Delete the FK relationship in DDT.</P><P>Deploy the database.</P><P>Create the FK relationship again with the desired cascade behavior.</P><P>Deploy the database.</P><P>Permanent solution:</P><P>DDT should understand that a change in cascade behavior requires the FK to be dropped and recreated and just do that.</P><P>Thanks!Mon, 04 Dec 2006 10:10:18 GMTChris Crabtree