Foreign Key actions (on update - on delete)
MartinH
Posts: 82 Bronze 2
Hi:
I am comparing 2 databases that have different actions specified under a Foreign Key actions, and these are not being picked up by SQL Compare.
This *may* be a SQLServer 2005 database issue as I am comparing a database foreign key with a 'No action' constraint and the other has a 'Set Null' constraint. Is 'Set Null' a new feature to SQLServer 2005? If so this may be the reason it's not getting picked up by SQL Compare.
Can anyone thow some light on this?
TIA,
MartinH.
I am comparing 2 databases that have different actions specified under a Foreign Key actions, and these are not being picked up by SQL Compare.
This *may* be a SQLServer 2005 database issue as I am comparing a database foreign key with a 'No action' constraint and the other has a 'Set Null' constraint. Is 'Set Null' a new feature to SQLServer 2005? If so this may be the reason it's not getting picked up by SQL Compare.
Can anyone thow some light on this?
TIA,
MartinH.
This discussion has been closed.
Comments
I think this is a feature of SQL 2005 as I can't find any information about this in 2000. If it is we currently don't support it.
We will be releasing an upgrade early next year that will be fully SQL 2005 compliant. Until then the version 3 tools will only support features that are found in both 2000 and 2005.
Regards
Dan
Red Gate Software Ltd