37 results found
I have multiple different objects between schema and i nedd to compare only onjects (filter objects) that corespond to a more complex criteria (not just by name). I would filter for example by creation date (in a certain interval), object type, eventually the name, and other custom criteria.
It would be very nice that in the project properties (or near the filter by name) user could have an edit box to edit the custom criteria.
For example, criteria could look like:
(objectname like 'TR%' or objectname like '%BN') and objecttype in ('VIEW', 'TABLE') and createddate>sysdate-3)
I have many different objects in my schemas, but i need to syncronize only objects created within last hours or day. It would be very nice to optionally filter object after a creatino date (or the objects that have creaing date).
I will put a new suggestion about a complete custopm filter (a string edited by user that is added to the where clause of SOCO)2 votes
I have check ignore schema in object comparison, however, Triggers still show as changed due to schema. Is this a bug or intentional?
The triggers in my database show that the schema is there when looking at the create sql via sql developer.
I have checked to ignore schema's in object comparison.
The source control for oracle sql does not have the schema in it.
Consequently the tool shows all triggers that have the schema as changes.
Shouldn't these be avoided due to checking of schema in edit comparison options...?3 votes
Add DB links owned by the schema in the snapshot creation / compare options.6 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
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
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.9 votes
Could it interpret the order to take same-named objects?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.
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.45 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
We are using Virtual Private Database on some schemas. These profiles are not included in current comparison.
Please include this. :-)3 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.29 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 votesRichard Mitchell responded
You can do this once you have performed a comparison the UI. I presume you mean using the “Create snapshot” in the start menu.
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.8 votes
as SQL Schema compare sdk5 votes
We are working to make Redgate Change Control and Redgate Change Automation available on Mac OS. These are our new migrations-based solutions. Redgate Change Automation is available as a docker container. You can learn more about this at https://documentation.red-gate.com/dso.
- Don't see your idea?