Include columns in Deployment that aren't in Compare
EdSabine
Posts: 2
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
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
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
Software Developer on SQL Compare and SQL Data Compare