Skip to content
← Oracle

How can we improve our Oracle solution?

Oracle: Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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…)
Thomas Steen-Larsen shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Catherine Kubitschek commented  ·   ·  Report

    I'd like to add my voice to this request as well. It's been almost 5 years since the original post and approaching 2 years from the planned implementation.

  • Anonymous commented  ·   ·  Report

    I would like to vote for this feature as well.

  • tulasi commented  ·   ·  Report

    Is to possible to test all tables at the same time when we have table names different in source and destination?

  • andrew commented  ·   ·  Report

    is this feature added yet?

  • Alan McCollough commented  ·   ·  Report

    I wished this was in the product; I have a need for it now, and am surprised it isn't a core feature. We got two tables in the same database, with one being made as a derivative of the first; and wish to compare the data between them. Can't be done currently. Argh!

  • Eric commented  ·   ·  Report

    This would be great for us also. We run a vendor update to an application that has a database backend. We will copy settings tables in the schema to TABLENAME_xxx_BAK prior. We then want to compare the two to make sure no settings were overwritten.

    Thanks

  • Anonymous commented  ·   ·  Report

    Hi
    We compare data every month, in order to find diff. between versions.
    We duplicate our tables and add a prefix to each of them.
    So we need to compare tables with diff. names.
    I would appreciate being informed , when this feature is available.

    Thanks
    Yossi

  • Dawn Pletcher commented  ·   ·  Report

    This is one functionality that is needed for my company to be able to use this tool. The reason we have different table names is because we create table via program executables, then we copy those tables to backup table name, then we run a new test version of the program and then compare those tables. Therefore, more times than not the tables reside in the same schema but they are name differently, thus I would be comparing these two tables: OUTPUT_BCK to OUTPUT.

  • AdminNeil Anderson (Admin, Redgate) commented  ·   ·  Report

    Hi Thomas,

    You are correct, this is a feature in SQL Data Compare. It is a good suggestion and we will consider it for an upcoming release. Can I ask why you have tables with different names that you want to compare? Do you add a prefix to those tables?

    Thanks,
    Neil