Comments
2 comments
-
Hi, thank you for your forum post.
Sadly SQL Data Compare will not allow you to map a single table in one database to multiple tables in another database.
The only workaround I can suggest, in the database with the 4 tables, create a view that links / joins the 4 tables, map the single table to the view you have created and compare the view to the single table.
Or
In the database with the 4 tables, create a view that links ' joins the 4 tables and in the database with single table, create a view that references the single table, ensure that the two views created map to each other and then compare the views.
To be able to compare views, you will need to enable Include Views option listed in the behavior section.
Many Thanks
Eddie
-
Sounds like a good idea, thanks!
Add comment
Please sign in to leave a comment.
https://documentation.red-gate.com/sdc14/setting-up-the-comparison/selecting-tables-and-views didn't have anything about it either.
Is this possible? I can create 4 different projects but I am hoping for a better solution than that
Thanks!