Data Compare for tables with Different Name.

• 
  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 D May 14, 2012 04:57

  - 0 +
• 
  Thanks for the reply.

  n3xus May 15, 2012 07:32

  - 0 +
• 
  "This would be very useful. And quite essential to our organization."
  
  I second this!
  
  Bruce

  mitchellbr October 28, 2013 08:41

  - 0 +
• 
  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 October 31, 2014 13:36

  - 0 +
• 
  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 03, 2014 06:48

  - 0 +
• 
  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

  richardjm November 03, 2014 06:50

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

  jkimrey May 09, 2017 16:44

  - 0 +
• 

  Hello

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

  regards

  fmoritz April 06, 2018 08:07

  - 0 +
• 
  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. 

  RichardL April 13, 2018 13:22

  - 0 +
• 

  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

  
  

  Ami April 20, 2018 16:01

  - 0 +
• 
  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. 

  RichardL April 20, 2018 16:08

  - 0 +

Add comment

Please sign in to leave a comment.