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

Include columns in Deployment that aren't in Compare

EdSabineEdSabine Posts: 2
edited September 20, 2016 8:22AM in SQL Data Compare
I have a situation where between 2 tables the PKs are completely different.
However the data is mostly the same.

I can retrieve the differences neatly by using multiple FKs in the compare and omitting the PK, but then the deployment script will break.

Is there a way I can omit columns from the compare, but include them in the deployment?


Many thanks,
Ed

Comments

  • Options
    Hi Ed,

    Apologies for not getting back to you sooner.

    It should be possible to do what you have described in Data Compare. Under the "Tables & Views" section of the edit project dialog you can specify a custom comparison key (the leftmost column) from which you could use your foreign key column as the comparison key. From the right hand column its possible to exclude columns from the comparison - so the original primary key can be excluded from the comparison and deployment if desired.

    I hope this helps with your issue

    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
    Matthew Chandler
    Software Developer on SQL Compare and SQL Data Compare
Sign In or Register to comment.