This website stores cookies on your computer.
These cookies are used to improve your website
experience and provide more personalized services
to you, both on this website and through other media.
To find out more about the cookies we use, see our
Privacy Policy
Answers
This can be done after running a comparison between two databases in SQL Compare and by clicking the filters button located at the top. After clicking filters, you can scroll to the table filter, click the pencil icon next to it. This will open a "Edit filter rules" popup menu which you can enter your filter into.
Regarding SQL Data Compare, there is no similar feature to be able to filter based on the table. The most you are able to do is type t_ in the search bar located at the top right, which does a blanket search of your tables/views to only include ones that have t_ in the name. Keep in mind this is more of a wildcard search, so it doesn't just look at the start of the name.
Kind regards,
Kurt McCormick
Product Support Engineer, Redgate
Need help? Take a look at our Help Center
The \[ is to escape the implied square bracket in object names (needed to restrict the tables to those tables that start with t_
sqldatacompare /s1:<server1> /db1:<db1> /s2:<server2> /db2:<db2> /include:identical /include:table:\[t_
Product Manager
Redgate Software