I have two tables
Table A(Guid - UniqueIdentifier - PK - default newid, other fields)
Table B(Guid - UniqueIdentifier - PK - default newid, A_Guid - FK to table A, other fields)
If the only thing that has changed between two versions of the DB is the fact that table A guid column does not have default, SQL compare failes to sync the change unless I select in the Deploy Changes wizard the option to use associated objects. This is something new to version 11. In version 10 it works perfectly
DanAvni
0

Comments

1 comment

  • Anu D
    Thanks for your forum post.

    Can you please reply my email with creation script for both the tables?

    And also by "associated objects" you mean in the Deployment Wizard at Step 3- Review Dependencies where you select "Deploy all dependencies"?
    Anu D
    0

Add comment

Please sign in to leave a comment.