What are the challenges you face when working across database platforms? Take the survey


DanAvniDanAvni Posts: 72 Bronze 2
edited December 15, 2014 4:53AM in SQL Compare 11
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
Dan Avni


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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"?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.