Data Compare for tables with Different Name.

n3xus · May 14, 2012 1:54AM

In my source DB table is named "t_Address".
But on my target table is named "Address".

"Data Compare for Oracle" is not recognizing them as same table, thus not giving me an option to edit "Where"

Is there any way I can get around?

Eddie D · May 14, 2012 4:57AM

Hi n3xus

Thank you for your post into the Data Compare for Oracle.

Data Compare for Oracle recognises the "t-Address" table in the source to be a different table to the "Address" table in the target and does not map them.

Sadly, unlike our SQL Data Compare, Data Compare for Oracle does not have a Table Mapping feature where you could manually map the "t-Address" table in the source to the "Address" table in the target. Therefore I have added the details of this forum post to an existing Feature Request to compare tables of different names. The reference number for this Feature Request is ODC-179. Hopefully this feature will appear in a future version of the Data Compare for Oracle product.

Many Thanks
Eddie

n3xus · May 15, 2012 7:32AM

Thanks for the reply.

mitchellbr · October 28, 2013 8:41AM

"This would be very useful. And quite essential to our organization."

I second this!

Bruce

twjnorth · October 31, 2014 1:36PM

Hi

Just started using Redgate. Impressed with the speed but yes - same request that it should be able to compare a table with a different name.

If it started as a SQL Server tool that has been ported to Oracle, do enhancements in the SQL Server version not automatically get added to the Oracle one ?

This call was logged in May so has there been any enhancements since then ?

Thanks

richardjm · November 3, 2014 6:48AM

No the code was forked a long time ago and subsequently cleaned up.

Data Compare table mapping will be the next big feature to be added to the tool and in fact in theory the engine already supports it, I hope to have something ready sometime this year.

Richard

(currently concentrating on Git support in Source Control for Oracle and storage options in the Schema Compare engine)

richardjm · November 3, 2014 6:50AM

Actually I should have mentioned, the best way to know when this is happening is to watch the user voice topic.

http://redgate.uservoice.com/forums/174 ... tablenames

jkimrey · May 9, 2017 4:44PM

Is this still not available? I still don't see the option in the latest version.

fmoritz · April 6, 2018 8:07AM

Hello

have you tested creating a view with the same name to be able to compare Table / View ?

regards

RichardL · April 13, 2018 1:22PM

Hi @fmoritz

Thanks for your post.

Please check the Data Compare for Oracle documentation page for the feature list.
It is linked below.

https://documentation.red-gate.com/dco4

Kind regards

Richard Lynch.

Ami · April 20, 2018 4:01PM

Hi,

Is it possible to compare huge data, like in terabytes. I mean table compare.

Also Which version of this tool is compatible with Oracle 9i

Thanks

RichardL · April 20, 2018 4:08PM

Hi @Ami

Thanks for your post.

Yes this would in theory be possible. The limiting thing factor is the comparison process creates TMP files and there needs to be enough space for these to be created.

We do support 9i. Please check the documentation link below for requirements.

https://documentation.red-gate.com/dco4/requirements-and-supported-oracle-versions

You can also search key words in the top right for queries you might have on functionality.

Kind regards

Richard Lynch.

Data Compare for tables with Different Name.

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk