What are the challenges you face when working across database platforms? Take the survey

Foreign Key actions (on update - on delete)

MartinHMartinH Posts: 82 Bronze 2
edited September 30, 2005 1:12PM in SQL Compare Previous Versions

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?



  • Options
    Hi Martin

    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.

    Daniel Handley
    Red Gate Software Ltd
This discussion has been closed.