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%32 votes
Things like lack of support of JSON objects, default on null on columns statements, and table compression statements cause us to use script rather than moving through the tool. The tool works great for things that have full support and would love to be running everything through it.32 votes
We’re working on this now, identifying new features we need to support for 12c. The tools already have some fixes and more will come through in the next few versions.
If you have particular pain points let us know here and we’ll prioritize those.
We’re currently hitting issues attempting to alter identity columns breaking the entire Oracle database which is worrying.
When your source or destination is an SVN repository allow to select a specific revision of the repository.
It is true that there are workarounds for this but it would save time to do it automatically in the tool because now either you have to checkout or update to an specific revision from the svn or you have to create tags in your repository for each version.25 votes
SQL Compare allows the user to use a customized filter to exclude specific objects, object types, or objects with a certain named pattern.
This would be extremely useful in the Oracle tool as well.23 votes
Create snapshot options should be similar to those in the SQL Server tool. We are currently limited to snapshot only from TNS and manual connection. We should have the options to create a snapshot from script file or source control. This is vital to our build automation13 votes
You can do this once you have performed a comparison the UI. I presume you mean using the “Create snapshot” in the start menu.
The tool does not support object type : JOBS .
The job belongs to the selected schema and the " schema compare / Source Control " ignores this type of object.7 votes
Be able to launch Schema Compare for Oracle from within Windows Explorer by clicking on the .ocp project file?
Received a support request from a customer looking to start or launch a comparison by simply clicking on the project .ocp file.
Redgate Software Ltd
Technical Support Engineer6 votes
Schema Compare should be able to ignore names for supplemental log groups. I have many differences on tables that I do not care about like this (the names were generated by GoldenGate):
ALTER TABLE schemaname.tablename ADD SUPPLEMENTAL LOG GROUP ggs_84245 (columnname) ALWAYS;5 votes
as SQL Schema compare sdk5 votes
Due to DML-only replication requirements target schema might contain only tables for related mview in source schema. In this case current configuration of SC shows difference: mview exist only on source and tables exist only on target. This is not correct if compare tables only.4 votes
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.4 votes
Severity: High Object: <schema>.<table> Title: UnsupportedDatatypeConversion Deployment cannot convert a DATE datatype to a TIMESTAMP(3)
This can be accomplished with an alter statement. Why isn't the tool doing that?
Sounds like this is a bug which is best raised via firstname.lastname@example.org
From what I can see DATE is equivalent to a TIMESTAMP without any timezone information. Looks like it isn’t one of our automatic conversions currently so we can add some test cases and make it happen.
Add option to filter out object that EQUAL.
In other words - show only differences/all/etc.
Add ability to go Next Difference (when usig show all)3 votes
We are using Virtual Private Database on some schemas. These profiles are not included in current comparison.
Please include this. :-)3 votes
Please add support or the ability to find Queue tables.1 vote
Could it interpret the order to take same-named objects?1 vote
- Don't see your idea?