Activity overview
Latest activity by JDSX
https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/32550040-custom-computed-comparison-key-for-matching-table / comments
https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/32550040-custom-computed-comparison-key-for-matching-table
sam.blackburn wrote: »
You'll probably need to create a view (in each database) joining the two tables, enable the "include views" option and select a comparison key using the Tables & Views tab. If you want to deploy data, you might also need to create an insert trigger on the view.
Hi,
That'd be ok for a workaround although I can't say I'd be thrilled by the added overhead and "pollution". A better solution would be adding a sort of computed comparison key to Data Compare. / comments
sam.blackburn wrote: »
You'll probably need to create a view (in each database) joining the two tables, enable the "include views" option and select a comparison key using the Tables & Views ta...
How to use parent tables to compare child tables that have different unique id's?
This is a common problem for us when using Data Compare. Parent table has unique constraint on a char field alongside an identity field which also serves as a one-to-many foreign key in the child t...