129 results found
-
Repository Change History is not Respected
On git when new Features are merged into Develop Branch , Source Control take Database Schema as Good and not the new changes on Develop. If like don't considerate last DDL TIme of an object to diff between new and old.
One example are Hot Fix merged on Develop branch, when a horfix was resolved and you are going to integrate changes in Develop Database, Source Control consider Develop Database as Good schema and not the new Hot Fix Change merged into Develop Branch. Generating Check In changes and not Get In Updates.
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 -
QA department demand, according GMP rules, for proof of same data export-import
Our QA department will need proof to show that the exported Oracle 11 data is the same when imported to Oracle 12 due to the strict GMP regulations that we need to be compliant with as pharmaceutical production facility.
As the Oracle database is part of software from a vendor we don’t do any development with Oracle. We only need the Oracle data compare tool for making sure that with the upgrade of software, the Oracle 11 data is the same as the imported data in Oracle 12 (before the new software will be installed).
The Oracle compare tool has…3 votes -
Project Display Order
Allow for manual ordering (e.g. drag and drop and/or move up / move down functionality) for Source Control Projects (vs. by name only)
3 votes -
Comparison Options: Add a Ignore option for Sequence Increment By
Sometimes in non-PROD environmens vs prod we may want to have different increment by clauses on sequences.
e.g. increment by 3 on non-Prod but increment by 1 on Prod
Would be be nice to be able to ignore differences in the increment by clause as an ignore options (similar to the ignore option for sequence current value)
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 -
Add the ability to build without a target database
The Azure DevOps extensions for SQL Server allow you to build the solution on check-in of new code without needing a target database to build against. Having similar extensions with this ability for Oracle to match what we can do with SQL Server would be fantastic.
3 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 -
Add the ability to delete items from the result list.
often when I am going through a compare or check in list, I am looking at changes and looking for a set of changes to check in, or a set of changes to make a script for. As I'm going down the list, I would like to just remove matches as I go. Sometimes I want to remove a whole block, then resort by something else then remove another block, so I can quickly narrow results down (and often don't want to create a filter for this, becuase it changes, this is more of a one time thing). Now if…
3 votesJust to confirm this is because the list doesn’t currently allow multiple rows to be selected currently. Correct?
-
View the parameters used in the creation of the project
Once created, there is no easy way to see which parameters were used (and none for things like username, and what the user connected as)
2 votes -
Allow indexes to be ignored
Various issues could be avoided by allowing indexes to be ignored when comparing.
2 votes -
Include support for ignoring ignored items in subversion
Include support for ignoring ignored items in subversion
This is NOT the same as filtering out objects. Once an object is in the svn:ignore it is supposed to be dead to subversion until revived.
2 votes -
Filter objects by created date
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 -
BUG!!!!
This has been an issue with Oracle tools for some time.
A table with a Generated column has a bug which inserts an extra right parentheses in its definition. Can be seen in Source Control as well as Schema Compare.
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1)) NOT NULL,
tool generates:
ColumnName NUMBER(1) GENERATED ALWAYS AS (NVL2("ForeignKey",0,1))) NOT NULL,
2 votes -
object history
I would like to have the option (like in TortoiseSVN) to be able to check all revisions in which the indicated object was changed (either by name or by click). The history of the specified object would be very helpful.
1 voteCurrently, in the tool, we only show all the history. If you use TortoiseSVN or another VCS client or command line, you can see the history for a particular object by locating that object's file in the repository and viewing that file's history.
-
Make Get Latest and Check in tabs buttons.
Why should the direction of update have to be selected by a tab? Why not have just one view with two buttons, one for "Apply to Source" and the other for "Apply to Database"?
1 vote -
Extend the project defintition
Source Control for Oracle could also become apart of the deployment project. This way you would like to have connections towards different databases in the same project. For instance I would like to have a connection towards development, test, qa and maybe even production for the same project. This way I could develop, pull changes to svn, push changes to test, then to QA, and at last to production.
It could also be very handy to be able to change the SVN (or have several SVN connections) for instance to a tag (release) library.
Then you could easily rollback to…1 vote -
Keyboard Shortcuts
The tool does not support keyboard shortcuts so a user must rely on slowly moving the mouse around to configure the app. An example is that to add multiple schemas, I have to click
Edit Project --> put my hands on the keyboard to search --> back to mouse to select Next --> Next --> Move mouse and select Edit Project... continueMany developers rely on keyboard shortcuts to speed work and it is common in most UIs.
1 vote -
Allow Locking feature to work with automatic re-compiles due to PL/SQL invalidation
It would be awesome if the tool would let automatic re-compiles work with Locked objects when a package spec/body is invalidated by a change to another package. As it is now - and automatic re-compile (without a code change) is blocked by the REDGATE.CHECK_LOCKS database trigger. Could Red Gate be changed to allow automatic re-compiles (as opposed to code change compiles)? Perhaps performing a checksum between the code and the Subversion repository could work (though this would require the database instance to communicate with the repository).Thanks!
1 vote
- Don't see your idea?