Data Compare for tables with Different Name.

Compares and synchronizes Oracle data

Data Compare for tables with Different Name.

Postby n3xus » Mon May 14, 2012 6:54 am

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?
n3xus
 
Posts: 6
Joined: Mon May 14, 2012 6:48 am

Postby eddie davis » Mon May 14, 2012 9:57 am

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 996
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby n3xus » Tue May 15, 2012 12:32 pm

Thanks for the reply.
n3xus
 
Posts: 6
Joined: Mon May 14, 2012 6:48 am

Re:

Postby mitchellbr » Mon Oct 28, 2013 1:41 pm

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

I second this!

Bruce
mitchellbr
 
Posts: 1
Joined: Mon Oct 28, 2013 1:37 pm

Re: Data Compare for tables with Different Name.

Postby twjnorth » Fri Oct 31, 2014 6:36 pm

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
twjnorth
 
Posts: 1
Joined: Fri Oct 31, 2014 6:33 pm

Re: Data Compare for tables with Different Name.

Postby richardjm » Mon Nov 03, 2014 12:48 pm

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)
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 494
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd

Re: Data Compare for tables with Different Name.

Postby richardjm » Mon Nov 03, 2014 12:50 pm

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
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 494
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests

cron