Allow partial compare of schemas based on naming convention
We manage ERP systems with larg schemas (150.000 - 200.000 objects) where only a small proportion - the custom objects - should be under source control / schema compared.
To enable a decent use of Schema Compare for these systems, we would need to be able to compare schemas partially based on naming convention. Multiple assignments per schema should be possible, e.g. we want to match all objects for schema ABC matching the naming convention EE% and FF%
Kevin Woolfe commented
I would go further and suggest that I would like to exclude specific objects from comparison in the settings for the project. In Data Compare, I can choose the tables to be included or excluded by clicking on the Table & Views tab. I would like to have a similar UI to tell Schema Compare to always ignore some objects.
Filtering by naming convention would be a start, but an Objects tab in Schema Compare similar to the Tables & Views tab in Data Compare would be more useful.
You can do something similar to this via the command line using the filter file from Source Control for Oracle (a very simple xml file).
We would like to push this feature back into the UI of Schema Compare for Oracle but we think it still needs a little more work to be really what people want.
For more information see http://documentation.red-gate.com/display/SCO3/Command+line+switches#Commandlineswitches-/filter:<filterfile.scpf>
We have a very similar situation with many people sharing a single environment with various projects against the same schema. This option would make it possible for us to script for CI vs manually picking each object in the UI as is required now.
Colin Rimmer commented
Allowing the user to compare a smaller number of objects would help general use of the tool.
So you mean you would like to define filters to include (or exclude) certain objects using some sort of regular expression syntax?