DisableKeys Option in SqlDataCompare
The generated SqlDataCompare script is attempting to delete rows in a parent table. This is failing as the table in question contains keys that are in use by foreign key relationships.
What needs to happen, of course, is that the foreign keys are disabled first, then the deletes and inserts occur, followed by the enabling of the foreign keys. After reading the help file I found the 'DisableKeys' option.
Unfortunatley this does not seem to have any affect. What am I missing? I have tried using both the command line and GUI versions of SqlDataCompare.
Thanks in advance.