What are the challenges you face when working across database platforms? Take the survey

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.

Best Answer

  • Options
    DanCDanC Posts: 607 Gold 4
    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?


  • Options
    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!

Sign In or Register to comment.