Identical columns will not map.

jdgwillard

When setting up the Project file, I am trying to add new columns to the comparison.

DB1 Column Description:
Name Type Null. Def. Col Order
ACATEGORY_PARENT_ID NUMBER Yes 0 15
ACATEGORY_NUMBER NUMBER Yes 0 16

DB2 Column Description:
Name Type Null. Def. Col Order
ACATEGORY_PARENT_ID NUMBER Yes 0 15
ACATEGORY_NUMBER NUMBER Yes 0 16

The Project mapper claims these are unequal. How can I get this to work correctly?

richardjm

Which version of the tool are you using?

Is there any chance of posting the full table creation script for both sides of the comparison to see what could be going wrong - you can email it to support@red-gate.com if you'd prefer not to post it.

jdgwillard

I am using version 2.1.0.353 of RedGate DataCompare for Oracle.

Both tables were created with the same script on different Oracle DB's.

I will email a copy of the script to you for reference.

richardjm

First thing I might try is updating to the latest version of the tool - currently 2.6.0.103 to see if that helps.

In case you're curious we're just finish work rewriting the Data Compare for Oracle command line tool so that it can be scripted much easier on the command line - that will hopefully be released in the next couple of weeks.

jdgwillard

Well, that seems to have fixed it! I didn't think to check if a new version was available.

Thanks very much for the assistance.

richardjm

Awesomesauce.

Happy it was that easy