Reading foreign keys error while registering data sources
dmoore2168
Posts: 2
Occurred when a foreign key is referencing a user table, however, the user table was somehow now a system table.
recreated the table as a user table, reapplied all the fk's and comparison works fine now.
recreated the table as a user table, reapplied all the fk's and comparison works fine now.
Comments
The behaviour you have found is correct. SQL Compare does not allow users to compare and synchronize system objects.
I hope the above answers your question.
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com