Can I compare only tables with specific schema using SQL Data Compare?

mjnincmjninc Posts: 16 Bronze 1
edited March 9, 2020 2:39PM in SQL Data Compare
Can I do a SQL Data Compare for only tables with a specific schema?  If so, how please?  Running version 14.


Tagged:
· Share on Twitter

Best Answer

  • DanCDanC Posts: 637 Gold 5
    Answer ✓
    Hi @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?

    · Share on Twitter

Answers

  • mjnincmjninc Posts: 16 Bronze 1
    edited March 10, 2020 5:12PM
    Thanks for your help.   Actually, I don't think I had to un-map them all.  I just went to owner mapping and highlighted the schema I needed and that seemed to work.  Thanks again!

    · Share on Twitter
Sign In or Register to comment.