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%
Specifically, please allow exclusion of packages, as our DBAs have restricted access to the all_source table.
(If you vote on this idea please mention any specific or general rules you'd like to pre-filter by)
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?