Sql server Migration Assistant for Oracle Type Mappings Problem RRS feed

  • Question

  • I am Migratign from Oracle database to Sql server 2008 using SSMA Tool.

    The problem is In Oracle I got few columns with

    Number(3,0)----->Want to convert to Int IN Sql Server

    Number(18,0)----> Want to Conver to Long in SQL Server

    I use the Type Mappings an I could not get correct conversion

    When I specify the type mapping both are getting covnerted to either
    Integer or Long(bigint),

    If so the problem arises at Application side because of covnersions


    Can't I specify Individual type mappings for each column

    Friday, August 5, 2011 7:07 AM


  • Hello,

    "From the Type Mapping tab, you can review the data type mapping where Oracle’s Number[*..*][*..*] is converted to SQL’s Numeric [*][*] data type."

    "You can update the mapping by clicking the Edit button and change the target type to int. Specify the range in the scale from 0 to 0 for conversion to integer. This option restricts to only convert when the Oracle data type has 0 scale. Click Apply button from the main data type mapping window to save the changes."


    You can also contact SSMA team directly at ssmahelp@microsoft.com.

    Hope this helps.  


    Alberto Morillo

    • Proposed as answer by Peja Tao Monday, August 8, 2011 5:37 AM
    • Marked as answer by Peja Tao Thursday, August 11, 2011 9:04 AM
    Friday, August 5, 2011 11:44 AM