129 results found
-
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 -
6 votes
-
Merge grants (or similar)
Here is the issue we are having.
Two developers are working on different instances of the same database schema. If both of them add grants to the same user or role to different objects an issue arises when trying to commit to the repository.
The user that commits second will have a conflict.
If they choose the repository's grants for that user, they will lose their changes on their instance.
It they choose the database's grants for that user, they will overwrite the other user's changes in the repository.It would be really nice to have one of these options…
5 votes -
5 votes
-
Multiscript tool - for Oracle
the ability to broadcast releases/upgrades is in the Multiscript tool...but only for SQL. Please implement for Oracle! Potentially hugely beneficial for some real-world cases
1 vote -
Command line interactive report
As with Schema compare tool, Data compare Tool should generate an interactive report.
3 votes -
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 -
Source Control for Oracle: Option to Resolve All Conflicts
Currently we have to select if each conflict should be resolved using the database or source control version individually. In our environment we always apply changes to the database so it is always the master. Would be very useful for us to be able to say resolve all conflicts using the database copy.
24 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?
-
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 votes
Richard 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.
-
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 -
6 votesRichard Mitchell
responded
You can now use any source control system in the v3 release of the tool by using “Working folder” which saves changes to disk and allows you to use external tools to commit and retrieve your changes.
-
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 -
Connection global for all Tools
Why i must create the same connection in each tool again? Please save connection strings global for all your tools and let me select the connection i need from a list within each of your tools.
24 votes -
Do not check CheckIn-Scripts for errors optionaly
Please give the possibility to CheckIn Scripts without error-checking optionaly!
5 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 -
Allow indexes to be ignored
Various issues could be avoided by allowing indexes to be ignored when comparing.
2 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 -
compare columns with different names
I am comparing two versions of a vendor application db, and sometimes they change columns names (even when not necessary). The tool needs a way to bind these two together.
It could be done with a simple mechanism under the hood, like simply creating a (new) common field alias name between the two queries.
It would be good if it could be implemented to allow general sql field query/conversion logic (where meaningful). For instance, sometimes even when keeping the name identical, other aspects of the field might have been changed which could lead to false positives for changes.
e.g. a…
7 votes
- Don't see your idea?