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

127 results found

  1. 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)
    You have left! (?) (thinking…)
    13 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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!

  2. 78 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    The Linux cmdlines for Schema Compare for Oracle, Data Compare for Oracle, and Code Analysis for Oracle are now available on Linux. These can be downloaded from https://documentation.red-gate.com/dso.

    We are also working on merging our Source Control for Oracle tool (our state-based database versioing tool) with Redgate Change Control (our mibrations-based database versioinng tool) to handle all your database versioning needs. This will be available on Linux. More information about Redgate Change Control is available at https://documentation.red-gate.com/dso/redgate-change-control/getting-started-with-redgate-change-control.

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

  3. 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)
    You have left! (?) (thinking…)
    8 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. We have dozens of schemas in our shared test database, and they're all part of the same project, so they would be versioned together.

    The current flow of the project creation wizard makes adding all these schemas one at a time to the new project a real pain.

    So, at the moment, when creating the project, we have to choose a single schema from Step 3 (Choose a Schema), then type in the name of the schema to serve as the folder name in Step 4 (Choose a Folder), then click "Add another schema..." and do the same thing again…

    53 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    In Redgate Change Control, our migrations-based versioning tool, users can specify multiple schemas in a comma separate list. We’re working to merge these tools together and have 1 tool for versioning database changes. When we do this, we’re hoping to make working with multiple schemas easier.

    Please let me know if you have any questions about this.

  5. 50 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. It would be convenient to be able to share source control projects with other users. Without this you either have to only have one person managing the sync between the database and source control system or each person has to create a project on their machine with the same settings.

    47 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    In 2019, we launched Redgate Change Control, our migrations-based versioning tool, which has a way to Open a project that you get from version control. We’re working to merge these tools together and have 1 tool for versioning database changes. When we do this, we’re hoping to make sharing projects with others easier.

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

  7. The tool does not support object type : JOBS .
    The job belongs to the selected schema and the " schema compare / Source Control " ignores this type of object.

    45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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)
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  All Oracle  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. Add the ability to perform push and pull requests through the Source Control for Oracle GUI

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    In our new migrations-based solution, Redgate Change Control, we treat Git as a Distributed Version Control system with Push and Pull capabilities.

    We are working towards merging these tools into 1 tool to meet all your database versioning needs. At that point, we should be able to provide push and pull for Git for state-based projects.

    For more information about version control in Redgate Change Control, see https://documentation.red-gate.com/dso/redgate-change-control/version-control.

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

  14. 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)
    You have left! (?) (thinking…)
    6 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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?

  15. If changes can occur in both the source and on the database directly, it would be helpful to know which was updated last and when.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. I have multiple different objects between schema and i nedd to compare only onjects (filter objects) that corespond to a more complex criteria (not just by name). I would filter for example by creation date (in a certain interval), object type, eventually the name, and other custom criteria.

    It would be very nice that in the project properties (or near the filter by name) user could have an edit box to edit the custom criteria.

    For example, criteria could look like:
    (objectname like 'TR%' or objectname like '%BN') and objecttype in ('VIEW', 'TABLE') and createddate>sysdate-3)

    The…

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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)
    You have left! (?) (thinking…)
    1 comment  ·  Data Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Source control for oracle polling interval should be configurable in UI like minutely/hourly/daily/weekly. This will help us reduce the burden in environments like test/uat/prod, where we don't this to become a performance issue.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Source Control  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Schema Compare  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    You can do this once you have performed a comparison the UI. I presume you mean using the “Create snapshot” in the start menu.

  20. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 6 7
  • Don't see your idea?