Options
Bug
DanAvni
Posts: 72 Bronze 2
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
Dan Avni
Comments
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"?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com