Data Compare for tables with Different Name.

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

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: 942
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


Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests