129 results found
-
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 -
Reporting Feature in Data Compare for Oracle
Please add further granularity to the number of rows to include when generating a HTML report. Currently the user can choose to "Only include first 1000 rows" or including all rows.
Please add further options to select:
Only include first 10 rows.
Only include first 1000 rows.
Only include 'x' number of rows.4 votes -
Constraints against other schemas
Include constraints that's against other schemas
4 votes -
portable installation
Oracle schema compare should install also in a portable way.
4 votes -
Update connections to support TLS 1.1 and 1.2
The lib's for external git connections do not use the more secure TLS connection protocols. Please update so users in security conscious environments can connect to secure servers that do not support SSLv3 and TLS v1.0
4 votes -
separate type spec and type body
Please separate type specifications and type bodies. (e.g. "CREATE TYPE FOO AS OBJECT" and "CREATE OR REPLACE TYPE BODY FOO"). Most of the time our changes are only to the body but Schema Compare will try to recreate the spec on deployment even if the spec has not changed.
This will fail if it has dependencies and make automated builds fail when using the Deployment Suite for Oracle with a build system.
4 votes -
Pre-script introduction in the scheme compare deployment script.
Hi , I am trying to understand how to introduce a pre-script ALTER SESSION SET CURRENT_SCHEMA = <> SQL statement in the top of the deployment script which is generated during the schema compare either between source DB vs target DB or TFS vs Target DB.
4 votes -
Exclude system-generated interval partitions from comparison and DDL
For background on Oracle's interval partitioning feature, see chapter 4 of Oracle Database Concept for release 12.2.
Our practice is to create interval-partitioned tables with the minimum number of partitions necessary to create the table (usually just one partition), and let Oracle create all others as data arrives requiring them. Between test, QA, and production databases, data arrives at different times, giving rise to automatic creation of different partitions. But because these differences are only a side-effect of different contents, they are not relevant, in the same way that differences in system-generated constraint names are not relevant. Changing the partition…
4 votes -
Foreign Keys not included in comparison if referenced table is excluded by the Ignore Rules Filter
This presents a problem for fully capturing table DDL definitions that are selected for the comparison
It is not immediately clear, and may be difficult to detect that FKs are excluded / failed to be captured, unless a full / unfiltered schema comparison is performed.
There is no indication that the FKs are suppressed and no setting will include them.
Are there any Schema Compare for Oracle and / or Source Control for Oracle users who would like to see the FK keys that reference Ignored Tables to be included in the deployment script or recorded in the DDL for…
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.
-
Source Control feature for Mercurial Kiln
Please add an option to directly integrate Source Control with the Kiln Repository. We could see no option other than GIT, Team, SVN etc.,
3 votesThe recommendation for this scenario is to use the “link to working folder” option in Source Control for Oracle.
-
Support for Serena PVCS
Please add support for Serena PVCS Version Manager (PVCS VM)
http://www.serena.com/index.php/en/products/pvcs-vm/3 votes -
support retargeting: allow to skip schema "refresh" when changing connection details and schema selection
This is a major issue
If I configure a compare between two schemas, with field restrictions, and where clauses, save it as a profile, and copy to a new file, those settings all get clobbered when I try to configure the same compare between two different schemas/instances.
Even if the setup as is definitely applies to these new targets, the tool reexamines the table structure, and enables everything, tossing all my configs, even when I don't want it to. I'm sure this was envisioned as a helpful 'feature', but it's needless. It's destroying my work, and could have been accomplished…
3 votes -
Command line interactive report
As with Schema compare tool, Data compare Tool should generate an interactive report.
3 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 -
Ability to select same schema as source and target specify scn or flashback time of both
Oracle has a feature called flashback query/schema that allows you to view a table/schema as of a particular timestamp. For some projects, there is a need to identify all the tables inserted/updated/deleted by a particular application process.
This would be an additional use case for Data Compare if it checked if flashback was enabled on the source and target schemas and allowed specifying a time.
Then it could be used for my use case - i.e. identifying what impact a particular front end screen or batch process had on the database.
It could also be used after a major incident…
3 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 -
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 -
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 -
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
- Don't see your idea?