How can we help you today? How can we help you today?

Identical columns will not map.

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?

3NlN9IZ.png
jdgwillard
0

Comments

5 comments

Sort by
  • 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.
    richardjm
    0
  • 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.
    jdgwillard
    0
  • 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.
    richardjm
    0
  • 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.
    jdgwillard
    0
  • richardjm
    Awesomesauce.

    Happy it was that easy :)
    richardjm
    0

Add comment

Please sign in to leave a comment.