Compare based on Selected Schema
I would be ideal if there was the ability to compare just a single Schema in databases. Example, exclude all dbo object and just include all objects in the XX schema. This would speed up the compare, as we would only be comparing objects in the XX schema and ignoring the 10K objects in the dbo schema.
Michael OBrien
shared this idea
This is possible using filters. You may not see a performance improvement, because the filter is applied after the comparison completes.
-
Brett Estes
commented
This would be great, and I would also love to be able to just exclude certain schemas and compare what is remaining. 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, but being able to filter this before the compare as part of the config would be beneficial.