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.

5 results found

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

  2. Specify tables to compare up front

    We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.

    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…)
    2 comments  ·  Data Compare  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    You can now use Ignore Rules to specify what tables to include/exclude in your comparison – https://documentation.red-gate.com/dco5/setting-up-the-comparison/using-ignore-rules.

    You also have the ability to specify what tables and WHERE clauses, if needed:
    - https://documentation.red-gate.com/dco5/setting-up-the-comparison/selecting-tables-to-compare
    and
    - https://documentation.red-gate.com/dco5/setting-up-the-comparison/filtering-the-comparison-with-a-where-clause

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

  3. support views not just tables

    the SQL Server version supports views

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

    I’ve just done initial work for this which should find it’s way into the next release. Obviously comparing and then syncing views depends a lot on their definition.

    This will be enabled by an option for the project which is off by default.

    This is now available via check for updates or to be downloaded from our website.

  4. Command line feedback

    Errorlevel is not updated by DCO32.exe if there are différences in data of two schémas.

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

    In the next release SDC should return 61 if there were differences or 62 if there were differences and the synchornization failed.

    This hasn’t been thoroughly tested to any issues please let support@red-gate.com know.

    By the way I can see you commenting on your own idea :)

  5. 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 →
    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

  • Don't see your idea?