Can I compare only tables with specific schema using SQL Data Compare?
mjninc
Posts: 16 Bronze 1
Can I do a SQL Data Compare for only tables with a specific schema? If so, how please? Running version 14.
Tagged:
Best Answer
-
DanC Posts: 641 Gold 5Hi @mjninc there's nothing officially documented on this and so I've come up with a method that might help you! if you edit your project within SQL Data Compare and change the "Owner mapping" and then unmap all the schemas you don't wish to compare and perform a re-compare. This will then only show tables mapped to the particular schema. Similarly if you're also curious about SQL Compare, you can achieve this much easier using the filters!
I hope this helps!Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers