Data Compare for tables with Different Name.

[n3xus]

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 davis]

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

[n3xus]

Thanks for the reply.

[thsla@statoil.com]

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

-Thomas