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)
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?