|
| | | StrataFrame Novice
 
Group: StrataFrame Users
Last Login: 07/09/2007 2:48:58 PM
Posts: 57, Visits: 107 |
| | To repro: Define a FK relationship. Deploy the database. Change the cascade behavior of the FK relationship. Deploy the database. SQL Server complains that you can't Alter--you must drop and recreate with the desired cascade behavior. Workaround: Delete the FK relationship in DDT. Deploy the database. Create the FK relationship again with the desired cascade behavior. Deploy the database. Permanent solution: DDT should understand that a change in cascade behavior requires the FK to be dropped and recreated and just do that. Thanks! |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 1:09:23 PM
Posts: 2,686, Visits: 1,888 |
| Aha... thanks for the report... I'll change the DatabaseMigrator to do just that when altering foreign keys. Thanks.
www.bungie.net |
| |
|
|