Exclude special schema from datacompare
I would be nice if you could set a filter in the project file which indicates which schemas to ignore.
So tables in this schema will never shown in the database project.
-
Traci Dennis commented
Bonus if it's similar to the SQL Compare filter pane so schemas/tables/views could have custom filter rules
-
Brett Estes commented
This would be great, and I would expand it to all objects. For example, we use cdc heavily, so I would like to be able to ignore the cdc schema completely. We also have a temp schema that is ignored by other tools (Azure DevOps, etc.), so I would like to specify for this to be ignored when doing comparisons.
In our case, it would be easier to select what to ignore than what to allow.