locked
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

Answers

  • 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."

    http://blogs.msdn.com/b/ssma/archive/2010/08/27/migrating-oracle-s-sample-hr-schema.aspx


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

    Hope this helps.  


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • 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