Skip to content

Oracle

Welcome to our Oracle solution feature suggestion site. Find out more information about our current offering at www.redgate.com/oracle.

If you have any questions, need help, or have found a bug, please visit the forums at forum.red-gate.com/categories/oracle-tools.

Oracle

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve our Oracle solution?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

131 results found

  1. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Add database objects to source control

    Please allow us to add database level objects to source control (schemas/roles/profiles/quotas/objects)

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. SDK

    as SQL Schema compare sdk

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Use Insert, Update, Delete commands instead of execute immediate

    I would prefer if the generated script would use insert/update/delete commands for each records instead of execute immediate.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Edit a project

    Please add a way of editing an existing project

    116 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    13 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    under review  ·  AdminStephanie (Product Manager, Redgate) responded

    In Source Control for Oracle v5.7, you can update your database credentials – https://documentation.red-gate.com/soco/release-notes-and-other-versions/source-control-for-oracle-5-7-release-notes.

    In 2019, we released Redgate Change Control, which is our migrations-based solution for versioning database changes. We are working towards merging these 2 tools into 1 tool for all your database versioning needs. At this time, we’ll hope to have a better way to edit other project information.

    Please let me know if you have any questions. Thank you!

  7. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. Support for IBM Rational ClearCase

    Please add support for IBM Rational ClearCase to Source Control for Oracle

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Richard 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.

  9. Exclude schema name in deployment script for Data Compare for Oracle

    When generating a deployment script in Schema Compare for Oracle you have the option to 'Exclude schema names in the deployment script'. Please could we have the same functionality in Data Compare for Oracle. This would be very useful when applying the script to different schemas.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Data Compare  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. Add Versioning Support for Directory Objects

    It would be nice if SC for Oracle could add versioning support for directory objects and their privileges.

    These are the directory objects that are created like this:

    CREATE OR REPLACE DIRECTORY temp AS 'c:\temp';

    and the list of directory objects comes from sys.alldirectories and their permissions from alltab_privs, like this:

    SELECT alltabprivs.*
    FROM alldirectories
    JOIN all    tabprivs ON (alltabprivs.tableschema = 'SYS' AND alldirectories.directoryname = alltabprivs.table_name);

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Add Versioning Support for Database Links

    It would be nice if SC for Oracle could have support for versioning both public and private database links.

    For private db links, because only the schema owner can create them, you might need to version them, but not expect to be able to create/replace them via the SC for Oracle interface, because the person logged into version control may not be the owner of the schema (and thus, couldn't create them). If nothing else, you could at least let us know when they differ from what's in source control, and we can manually (outside of SC for Oracle) adjust…

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Revert to a previous version

    Please add the ability to revert my schema(s) to a previous from the history tab.

    I understand this is currently possible by checking the version out to a folder, and using Schema Compare to deploy changes, but it would be much more convenient (and cheaper!) from within Source Control.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. Undo changes before they are checked in

    Please add the ability to undo changes to an object in the check in screen. They should be undone to the latest version in source control.

    Much like this feature in SQL Source Control: http://www.red-gate.com/supportcenter/content/SQL_Source_Control/help/3.1/SSC_Undo

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminStephanie (Product Manager, Redgate) responded

    For any objects that are CREATE OR REPLACE, highlight the code under “Source Control” in the check-in screen and execute it in your schema to get back to the version in source control.

    This will not work for tables and please keep voting/commenting here if you need this.

  15. Support versioning Java within the Oracle database

    Please add support for versioning Java source code within the Oracle database, for example Java Stored Procedures

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. Maven plugin

    With a maven plugin developers could easily automate deploys. The plugin should be configureable, but include the possibilites of first pulling from a developer database into svn. Then pushing the changes from svn (including other changes registered in SVN) towards a deploy test database.

    36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. Provide a merge option for conflicts

    Instead of take database version, or take source control version, we sometimes wish to merge the two changes.

    (If you vote on this idea please also mention any tools you use for merging files in source control)

    54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    8 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. Add support for Vault to Source Control for Oracle

    Please add Vault support

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Richard 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.

  20. Option to automate check-ins

    We would like to have an option to enable automated check-ins. Basically, this should poll the database after every "x" minutes and see if there are any pending changes and use a automated comment like -

    "Changed these objects on [date/time] by [xyz] -
    table1,
    view1,
    package1,
    package2
    function1"

    (Please add any more relevant data you feel would be necessary)

    Ideally, we would want to check in every script as soon as it is deployed in the database. But since, for doing that you would need an extension in our IDE, automated polling would be sufficient as well. The aim…

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Richard Mitchell responded

    I’m not sure how generally useful this feature would be. I’m trying to understand your use case to see what problem you’re trying to solve.

    Could you give me more details?

1 2 3 4 6
  • Don't see your idea?