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.

23 results found

  1. Support Mercurial

    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…)
    4 comments  ·  Source Control  ·  Admin →
    declined  ·  AdminDavid Atkinson (Product Manager, Redgate) responded

    This item will be closed. You can now use Mercurial by using “Working folder” which saves changes to disk and allows you to use external tools to commit and retrieve your changes. This requires use of your own Mercurial client tool, but feedback indicates that this is preferred as it grants more control over commits and pushes, and allows atomic commits. Please get in touch if you have any questions.

  2. check-in comment/message as mandatory field for commits to a repository

    Please provide an option for Source Control to make the check-in comment a mandatory field for all commits to a repository. Commits/check-ins without comment should be rejected. With the current Version of Source Control (5.3.1.2355) it is possible to commit changes without a comment to a git repository in Azure DevOps - even though a local git repository doesn't allow to commit without a message.

    24 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 →

  3. Include Table and Column comments in the documentation

    When creating documentation in Schema Doc, I'd also really like to document tables and column comments.

    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…)
    0 comments  ·  Schema Doc  ·  Admin →

  4. Offer ways to customize extensions and folders to each object type

    Would be nice to be an option to customize the folder names and the object types related to this folders, same for the file extensions.

    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…)
    1 comment  ·  Source Control  ·  Admin →
    declined  ·  Richard Mitchell responded

    I’m afraid this is too large a change to the structure of the engine to be supported.

  5. It won't allow me to compare two schemas from different databases with the same name

    Please llow me to compare shemas with the same name.

    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  ·  Data Compare  ·  Admin →

  6. Oracle-to-SQL Server migration/synchronization

    I have 2 current opportunities with a couple of the largest company's in the US/UK for Oracle-to-SQL Server migration for both and synchronization for 1. This is a big space to get into, but judging from experience with Red Gate in the SQL Server space, I think Red Gate can grab significant market share from the likes of GoldenGate.

    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 →
    declined  ·  AdminDavid Atkinson (Product Manager, Redgate) responded

    Thanks for the product idea. At Redgate we favour tools that have repeat use cases. Platform migration tools are often used once or twice and then shelved. Also, for obvious reasons there are always decent free options provided by the platform vendors.

  7. Three way data merging with DCO

    Is there any plan to support three way merging? Right now DCO is more like pushing or copying then merging. Hopefully Red Gate can support three way merging to make it more useful.

    Steps
    - Schema A, B, and C are all same.
    - Change data in schema B, also change data in schema C
    - Now do three way comparison, and merge changes back from B to A, and also C to A.
    (Optionally, we can push changes back to B, C to make all A, B, and C same again)

    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  ·  Data Compare  ·  Admin →
    declined  ·  Richard Mitchell responded

    We have no plans for this change. It would mean far too major changes to the engine and UI and the way the tool can work.

    This could be done currently via the command line and running a series of comparisons one after the other.

    (Also, we plan to rewrite the command line this year to make it more useful as currently the Data Compare one requires project files generated by the UI to work)

  8. bug on context index and xmltype column

    Refresh afte commit changes show incorrect changes with context index on xmltype column.

    For example:
    create table t1(col xmltype);

    create index idxtest on t1(col)
    indextype is ctxsys.context
    parameters ('datastore ctxsys.default    datastore
    filter ctxsys.nullfilter
    section group ctxsys.auto    section_group
    sync (on commit) memory 16m');

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

    I’ve confirmed this issue and raised it as OSC-357 unfortunately as it was an anonymous submission I can’t respond to you directly.

    I’ve declined this as a feature as it’s a bug report

  9. Synonym comparison limitations?

    I have a schema where synonyms are not being compared correctly. In particular this is a synonym that refers to a remote object. Is this a known limitation of Schema Compare?

    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…)
    declined  ·  0 comments  ·  Schema Compare  ·  Admin →

  10. Add a documentation tool to the Oracle side of things

    It would be great if you would produce/migrate this product(SQL DOC) over to the Oracle environment! I have used it before in the SQL Server realm, but now in a new job that is an Oracle shop... Would be nice to have this tool here as well!
    Thanks in advance,
    Kevin Orcutt

    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…)
    1 comment  ·  Schema Doc  ·  Admin →
    declined  ·  AdminStephanie (Product Manager, Redgate) responded

    From our understanding, this is available in SQL Developer:
    To generate documentation (in HTML format (comparable to Javadoc for Java classes) about a schema, right-click the connection name in the Connections navigator display and select Generate DB Doc. To view the generated documentation, open the index.html file in the output directory that you specified.
    https://docs.oracle.com/cd/E35137_01/appdev.32/e35117/intro.htm#RPTUG45343

  11. comparing on Joins, rather than just "where" clauses

    in order to restrict the scope of rows to compare, it is often necessary to join the real table under examination with another, rather than just a standard "where" clause.

    allow use of joins with conditions

    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…)
    0 comments  ·  Data Compare  ·  Admin →
    declined  ·  Richard Mitchell responded

    You can perform complex WHERE clauses related to other tables by using other forms for example.

    ID in (select OTHERID from OTHERTABLE)

    Hopefully this workaround is satisfactory.

  12. The function of Schema Compare that compares schemas with script folders has the problems that it ignores all extentions different than sql.

    It would be useful to support files with different extensions, either by allowing to configure ignored extensions (all other will be treated as sql) or by allowing to configure extensions for specific types of objects.

    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…)
    0 comments  ·  Schema Compare  ·  Admin →
    declined  ·  Richard Mitchell responded

    What scenario are you trying to support here? We only support comparing to sql that we have generated initially and we always save the files ending in .sql.

    It may work against arbitrary sql files (and I tend to fix issues when they’re reported) but it’s not something we “support”.

    Without further information I’m closing this request.

  13. Only prompt for save if options have changed

    Hi,

    First, thanks for this tool. It has been a life saver for me.

    Secondly, everytime I do a compare it requests to save changes to the ocp file. Everytime I sit there and think about whether I changed anything or not. Most often I haven't.

    It would make life easier if it didn't prompt every time.

    Regards.

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

    A project is modified if you change the selections to deploy as these are stored with the project.

  14. Streamline the workflow

    Hi,

    I am developing on my local machines and then deploy to my customer's development machines. I am deploying at least 2 to 3 times a day to at least 2 different databases.

    Every time I do this I get the OCP selection box, cancel, select the OCP file I need, click on compare, click on the differences I want to deploy, click on deploy, click on next (I always deploy directly to the destination), click on deploy now, click on are you sure.

    I'm sure this can be streamlined and simplified. Don't use modal dialog boxes on top of…

    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 →

  15. Add an ignore option for Schema Compare to skip when errors occur, e.g. Error: Object reference not set to an instance of an object

    Error: Object reference not set to an instance of an object is displayed and Schema Compare stops. It would be better if it were possible to continue beyond this error and just have a logfile of errors with details of the objects that failed.

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

    The problem with supporting this is that once the first error happens (e.g. failing to populate a table) the errors snowball (now the view that uses that table fails, the index for that table also fails) to such an extent that it’s very difficult to find the first failure.

    Submitting error reports to us is the best way to get fixes.

  16. Provide an parameter to allow Schema Compare for Oracle to execute serially. I am frequently, but not alway getting Memory Exceptions when

    Provide an option to allow Schema Compare for Oracle to execute serially. I am frequently, but not always, getting a Memory Exception when using Schema Compare for Oracle. The error always occurs during the “Registering database one” and “Registering database two steps”. These steps always run in parallel. It also always occurs during the “Populating table columns” part of the step. If I could run this serially, I think these errors would go away.

    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 →

  17. Respect svn:ignore in Source Control for Oracle

    Source Control for Oracle does not seem to respect svn:ignore property. Please include that in a future release s owe can exclude test tables, procedures, and the like.

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

    The upcoming release adds a feature called “object filtering” which can be set on a project level and stored in source control. With this you can exclude whole object types or just objects that “contain” a substring e.g. “Test_” you can then override the exclude with another “contain” string setting e.g. “Test_Important” should too much be excluded.

    It’s got a simple UI accessed via the right-click menu on the main projects screen.

  18. Include a "Open project"-button on dialog upon start-up

    A very small wish....

    When I start the program, a dialog-window with the latest project worked on is shown. That is good as long as this often is the project I shall work on.

    But could you please add a "Open project"-button on this dialog.

    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 →

  19. get latest - mixing and matching use database version and use source control version

    Please note I am on version 2.x beta:

    There appears to be some issues when mixing and matching the following options "use source control version" and "database version". When I tried to check my changes in on the check-in tab i received an error "check-in failed some objects were out of date. Review changes and check in again". Tried to submit this as an error with the report button but I get a System.NullReferenceException.

    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 →

  20. Schema Compare - Local Indexes

    when migrating indexes in schema compare,bitmap indexes on a partitioned table fail - local clause missing

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

    You have to turn off “ignore storage” to copy partition information from one database to another. I am in the progress of making this option more granular.

    If you are submitting a bug report support@red-gate.com is the best way.

← Previous 1
  • Don't see your idea?