36 results found
-
Schema Compare Report -silly to have separate images folder for each interactive html report
When using the interactive html report currently a new folder for each new report is generated containing the exact same images. There should just be a general images folder by all reports. Alternatively there should also be an option to use images from redgate website remotely. This would make it easier to send out differences reports as e-mail.
3 votes -
Schema Compare Report - identical objects should be filtered too
When generating a schema compare report there is the option to "Also include identical objects". When you choose that you get again ALL object types of identical objects. I want to be able to include only the identical objects of the filtered object type, which is possible for differing objects via choosing "Objects selected for deploment". I think objects excluded by filter should also be excluded in the report, no matter what.
3 votes -
Optional, exclude by default dependent (affected) objects from deploy
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 -
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 private DB links
Add DB links owned by the schema in the snapshot creation / compare options.
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.
Many Thanks
Eddie DavisRedgate Software Ltd
Technical Support Engineer6 votes -
hide
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 -
New option is needed to compare mviews as just tables (ignore mview definition)
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 -
When changing a table to a view Schema Compare does not drop table first, and then create view.
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?
Thanks,
Mike4 votesSounds like this is a bug which is best raised via support@red-gate.com
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.
-
Schema Compare should be able to ignore system generated names for supplemental log groups
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 -
Include policy-comparison for tables
We are using Virtual Private Database on some schemas. These profiles are not included in current comparison.
Please include this. :-)
3 votes -
Allow schema comparison from a specific revision of the repository
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 -
snapshot
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 automation
13 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.
-
Add database-level objects to schema (database?) compare
I'd like the ability to compare schema, role and other database level objects for deployment. Most notably schemas (users) and roles.
8 votes -
SDK
as SQL Schema compare sdk
5 votes
- Don't see your idea?