129 results found
-
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 -
Performance
The step where the product (Source Control for Oracle) accesses the Oracle instance to return a list of schemas is taking a long time to run, and in one of my development instances, it actually fails to finish.
It seems to be running the following SQL
(SELECT username, 'TRUE' as isempty from allusers
minus
select owner, 'TRUE' as isempty from allobjects)
union all
( SELECT username, 'FALSE' as isempty from allusers
intersect
select owner, 'FALSE' as isempty from allobjects)if the query accepts parameter(s), it should speed up that part tremendously.
(SELECT…
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 -
Roaming Profiles
Please don't save the parameters like ConnectionStore.xml and LinkedDatabases.xml in the LocalApp-dir in the Userprofile.
We have activated roaming profiles and die LocalApp-Dir doesn't save and load again, if I logoff and logon on another computer.4 votes -
Visual Studio extension
We use TOAD extension for Visual Studio. The one nice thing about that tool is that it integrates the database project with our solution (and TFS), and offers a way to Deploy the database from the scripts that the TOAD extension creates (tables, procedures, etc). It also has a way to run a pre and post deployment scripts. Would be fanstatic if the redgate tools had this as well.
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 -
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 -
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 -
Virtual Columns Should Be Ignored By Default
Since you can't update the values, why compare them in the first place?
3 votes -
Locking and unlocking the objects in Oracle
Hi Team,
Lock and unlock the objects in oracle. Anyone can unlock and lock the objects, but our requirement it's should be configurable. some admin or some user has control to unlock the objects.
For example, User ABC Locked the EMP tables currently anyone can unlock the objects but it's should either ABC user need to unlock or give some admin user to unlock the objects. We need to some control required to maintain the locking and unlocking the objects and there is no audit info as well.
3 votes -
Include option to create refresh groups (like Refresh Group X)
Would be nice to be able to include projects into fresh groups -- so group or similar projects could be refreshed together.
Individual refreshes may become tedious, and the Refresh All may be too broad.
Alt as a simpler implementation provide the ability to exclude projects from a bulk (Refresh All) -- e.g. by marking a project as inactive.
Example:
If I have 15 projects total:
- 5 defined as belong to Group A,
- 4 belong to Group B,
- 4 are unaffiliated
- 2 are inactiveWould like to be able to:
- refresh Group A (project count:…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 -
wildcard
Please add advanced filtering in Schema Compare. E.g. wildcard or regex matches to only show objects matching a certain criteria.
3 votes -
Command line interactive report
As with Schema compare tool, Data compare Tool should generate an interactive report.
3 votes -
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 -
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
- Don't see your idea?