Comments
Sort by recent activity
Are you able to post the content of your .scpf file (make sure you redact your table names)? / comments
Are you able to post the content of your .scpf file (make sure you redact your table names)?
In Redgate SQL Compare, go to the "Actions" menu and click "Filter setup pane". This will allow you to configure it to just compare the specific tables you want. To start off with, configure it to only include two of your tables, then click on the floppy disk icon: "Save the current filter". Once you've saved this, you can then open the and view the format of filter file that is created. After you've familiarised yourself with the syntax of this file you can generate your list of tables and insert it into the filter file at the appropriate location e.g.: <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<!--
SQL Compare
SQL Compare
Version:14.2.16.16006-->
<NamedFilter version="1" type="SQLCompareFilter">
<!--This filter can be loaded using the SQL Compare UI or used with a SQL Compare command line session using the /filter switch-->
<FilterName>Filter</FilterName>
<Filter version="1" type="DifferenceFilter">
<FilterCaseSensitive>False</FilterCaseSensitive>
<Filters version="1">
...
<Table version="1">
<Include>True</Include>
<Expression>((name = 'TableA') AND (name = 'TableB'))</Expression>
</Table>
...
</Filters>
</Filter>
</NamedFilter>
/ comments
In Redgate SQL Compare, go to the "Actions" menu and click "Filter setup pane". This will allow you to configure it to just compare the specific tables you want. To start off with, configure it to ...