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
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