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.40 votes
We are actively working through 12c features. Please keep telling us which features are most important to you.
Each release adds more support for 12c, when this work is finished there will be a major version upgrade and we are considering dropping 9i support soon afterwards
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%35 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.26 votes
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.26 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.11 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.7 votes
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.7 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;6 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
as SQL Schema compare sdk5 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 the ability to compare / snapshot Oracle chains, programs, and scheduler / DBMS jobs owned by the schema. They can reference a PLSQL block in the chain too. A chain that references a stored procedure will have the target in there already under the "Procedures" section.3 votes
Add DB links owned by the schema in the snapshot creation / compare options.3 votes
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
I have 2 current opportunities with a couple of the largest company's in the US/UK for Oracle-to-SQL Server migration for both and synchronization for 1. This is a big space to get into, but judging from experience with Red Gate in the SQL Server space, I think Red Gate can grab significant market share from the likes of GoldenGate.3 votes
In 99% of cases i need NOT to deploy affected objects. I do small, incremental deploys.
So i need an option so that SOCO, at deploy, will uncheck be default the checkbox "Deploy all affected objects" and to uncheck all the items in the affacted items list.
There are cases when, if I forget to uncheck "Deploy all affected objects."and to uncheck "objects affected" I will put some productions down.1 vote
Please add support or the ability to find Queue tables.1 vote
- Don't see your idea?