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.

59 results found

  1. Please add possibility to compare and copy table and column comments

    We work a lot with table and columns comments, so they are mandatory. It would be nice to be able to compare the comments as well and be able to copy them.

    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  ·  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
    completed  ·  Neil Anderson responded

    this has been included in Schema Compare 3.0.0.542 and Source Control 1.0.0.707

  2. Allow limiting the deployment to only differences and objects missing , without project , at command line

    I must prevent to drop any tables, because the database may contains other tables for another application.
    And yes , they are in same schema.

    I need to deploy database changes on multiple databases, at client site, from a single snapshot.

    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
    completed  ·  Richard Mitchell responded

    In the upcoming release drop table and drop column are both classed as high-level warning events which can easily be stopped. The command line tools as an option to not deploy if there are medium or high level warnings.

  3. Synonym support

    Generate a script that contains all the synonyms that have been created to support the schema being version controlled.

    9 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
    completed  ·  Richard Mitchell responded

    I believe this is a request for public synonyms which has been implemented in the latest release.

    Please let me know if that’s incorrect.

  4. Add support to ORACLE_LOADER and ORACLE_DATAPUMP access drivers

    Add support to ORACLELOADER and ORACLEDATAPUMP access drivers to fix some bugs related to external tables (see http://www.red-gate.com/MessageBoard/viewtopic.php?t=16543)

    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

  5. Allow source control in sub-folders of repository

    Allow for saving of database versioning in a sub-folder of the subversion repository rather than just the root of the repository.

    4 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
    completed  ·  Anonymous responded

    This should now be fixed in the beta released yesterday (21 Feb), please do let us know if there are still issues!

  6. Put package header and body in seperate files.

    When a repository is created from the database, both the package header and the package body are placed in a single file. It would be more usable if the spec and body were in separate files in the same folder with a .pks or .pkb extension respectively.

    9 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
    completed  ·  Neil Anderson responded

    this will be in the next release of Schema Compare and Source Control for Oracle

  7. Allow us to choose the schema prefix

    We noticed that all objects have a prefix in front of it.
    The prefix happens to be the same as your folder name. I would prefer it if it was the same as the schema name, or NULL. Preferably give us the right to choose a prefix name.

    9 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
    completed  ·  Richard Mitchell responded

    I believe you can do this in the latest version of Source Control.

    Either you can make your schema name the same as the folder when you setup your project.

    Or you can now access the options via right-click on the project on the projects page and select “Edit comparison options…” and use the option “Exclude schema names”

  8. Compare tables with different tablenames

    Could you please make it possible to compare tables with different tablenames?

    This should be applied to all tools.

    I do believe this is possible in the SQL Server-tools.

    50 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…)
    9 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

  9. Allow partial compare of schemas based on naming convention

    We manage ERP systems with larg schemas (150.000 - 200.000 objects) where only a small proportion - the custom objects - should be under source control / schema compared.

    To enable a decent use of Schema Compare for these systems, we would need to be able to compare schemas partially based on naming convention. Multiple assignments per schema should be possible, e.g. we want to match all objects for schema ABC matching the naming convention EE% and FF%

    40 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…)
    5 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

  10. SID is limited to 8 characters

    The SID for my oracle instance is 10 characters. The connection wizard only allows 8 characters so can't use the product.

    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…)
    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

  11. Match source when creating repository files.

    When checking in a new package from the database, the schema name in references throughout the package is changed to have double quotes around it. Then when a change is made on the file, the entries from the database without the double quotes do not match the entries from source control with the double quotes. It seems that this difference alone isn't enough to show the comparison as different, but when another difference exists, these entries are all flagged as different. To resolve this, the double quotes should not be created in the first place.

    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…)
    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
    completed  ·  Anonymous responded

    Thanks Leigh. We believe this is fixed in the latest beta release, please do advise.

  12. Include materialized views in the schema compare

    It seems materialized views are not included in the compare. Or am I missing something?

    11 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…)
    3 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
    completed  ·  Neil Anderson responded

    Materialized Views and MVIEW Logs are now supported in v3.0.0.686. Available via Help→Check for Updates

  13. dotNet version

    System requirements for Schema Compare tell us about "Microsoft .NET Framework version 2.0 or later." Actually, the last version requires .NET version 4. The previous build required version 3.5 exactly. Such mess in versions frustrated me.

    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  ·  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
    completed  ·  Anonymous responded

    Many thanks for reporting this Sergey, we have now updated that page. We are using some features in .NET 4 for the latest version, apologies for the frustration, we won’t be updating again for a long time now.

  14. Help Contents - 404 Error

    I'm getting a "404: Page not found" when clicking on the "Help Contents" in version 3.0.0.219.

    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  ·  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
    completed  ·  Brian Tufnell responded

    Hi Curtis

    Thanks for reporting this. As Neil mentioned previously, a redirect link on our website was broken.

    I’m pleased to say it’s now been fixed, so when you click “Help→Contents” it will take you straight to the V3 help page.

    Cheers,

    — Brian

  15. List Schema's Alphabetically

    Please sort the list of schema's alphabetically. Things show up in kind of a strange order right now.

    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  ·  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
    completed  ·  Brian Tufnell responded

    Hi Bjorn – many thanks for your feedback. We had noticed this, and a similar issue with the ordering of TNS names, in our own testing recently. Both issues are fixed in Schema Compare for Oracle V3 which we’re expecting to release commercially in a couple of weeks. The major new functionality in this version is the ability to compare and deploy your schema to a scripts folder, which you can then put under source control. If you’d like to try V3 before then, you can download it by signing up to the Source Control for Oracle beta program on the Red Gate website.

  16. Problem with schema compare 3

    With large Oracle schemas it appears to hang at 44% with idle connections to the databases it is comparing.

    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…)
    1 comment  ·  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
    completed  ·  Brian Tufnell responded

    Hi Curtis

    We think this should be fixed in the latest version of Schema Compare for Oracle which you can get by using the “Help→Check for updates” menu option in the tool.

    If you could please try your comparison again with this new version, and let us know how it goes.

    Cheers,

    — Brian

  17. Source Control Option - Generate object scripts in schema sub-folders

    Source Control Option

    When comparing multiple schemas all objects of same type go into one folder (e.g. all tables from all schemas into tables folder). In Oracle you normally look at objects by schema then type rather than this other way round.

    Please provide option (and set as default) to export into schema sub-folders then object type folders

    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  ·  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
    completed  ·  Brian Tufnell responded

    This is now implemented in version 3.0.0.196 which you can get via the Help menu in the tool (Help→Check for Updates).

    In this version multiple schemas are written to multiple sub-folders by default (the user just selects the parent folder) – we’ll look at adding a user-defined option to override this behaviour in a future release.

  18. TNSNames list sorted?

    On New Project list, can the TNSNames list (to connect to the db) be sorted alphabetically? Just makes it easier to browse.

    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  ·  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
    completed  ·  Aaron Law responded

    Update: v3 of Schema Compare has been released which includes this feature.

    Thank you for the suggestion! I’ve implemented this change for you on our early access branch and it will be included in the full product once the EA is complete. In the meantime you can get the EA from:
    http://downloads.red-gate.com/EAP/SchemaCompareforOracleBeta/SchemaCompareforOracleBeta.exe
    (this will install alongside any version you currently have installed if you want to give it a go)

  19. Data Compare for Oracle: Option: Comparisaon behavior - Trim Trailing Spaces: Is it possible to uncheck by default this option?

    When I used this tool, I want that, by default, he copies over all data exactly the same as they exist in the source; so including trailing spaces.

    In my opinion you set/change an option if you want that your data should be 'transformed' during the transfer form source to target. At that moment, it is a conscious choice.

    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…)
    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
    completed  ·  Anonymous responded

    Hi Jan,

    I’m going to close this as David mentions you should be able to save your default comparison options. Do let us know if that isn’t the case.

    Michael

1 3 Next →
  • Don't see your idea?