Reading foreign keys error while registering data sources

dmoore2168dmoore2168 Posts: 2
edited July 25, 2011 5:35AM in SQL Compare Previous Versions
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.

Comments

  • Eddie DEddie D Posts: 1,779 Rose Gold 5
    Thank you for your post into the forum.

    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.
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.