SSMA Console for Oracle - Column Type Mapping Error (conflict with the existing one)

Ben Whitelock 21 Reputation points
2021-09-21T05:24:36.437+00:00

Using SMA Console for Oracle I have added the following column type mapping:

<set-project-type-mapping type-mapping-schema="Columns type mapping" source-type-id="NUMBER@2" target-type-id="INT" />

However, when I execute this via the SSMA Console I get the following error:

FATALERR Invalid type mapping: The new type mapping from source 'NUMBER@2' to target 'INT' has a conflict with the existing one.

Please can someone advise how to avoid this mapping conflict. I am creating a new project with the script file.

Thank you,
Ben

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
0 comments No comments
{count} votes

Accepted answer
  1. Xiao Yu 81 Reputation points
    2021-09-22T18:14:45.237+00:00

    Hi, as "NUMBER@2" expects two parameters and you want to overwrite the old mapping, then you need you specify the source type exactly the same as the existing one, which should be like this:

    <set-project-type-mapping type-mapping-schema="Columns type mapping" source-type-id="NUMBER@2" target-type-id="INT">
        <source-type-param />
        <source-type-param />
    </set-project-type-mapping>
    
    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful