locked
Oracle to SQL Migration using SSMA6.0 : Error while data migration from Oracle Rowid to Sql uniqueidentifier RRS feed

  • Question

  • Hi Team ,

    I am doing migration from oracle11g to SQL server2012. Facing error while data migration from Oracle rowid dat typeto SQL uniqueidentifier using SSMA6.0

    Errors: The given value of type String from the data source cannot be converted to type uniqueidentifier of the specified target column.

    Refer above error 

    Please assist how to handle

    Thanks,

    Pramendra

    Monday, October 12, 2015 12:52 PM

Answers

  • Hi Pramendra,

    According to your description, you get the error” The given value of type String from the data source cannot be converted to type uniqueidentifier of the specified target column” when doing a migration from oracle11g to SQL Server 2012. We need to verify that if you add rowid columns to tables in SQL Server, if not, please set the generate rowid column option to ‘Yes’ or add rowid column for tables with triggers in the SSMA project settings, then check if you can migrate data successfully. For more information of migrating data from Oracle to SQL Server using SSMA(SQL Server Migration Assistant), please refer to this article: Guide to Migrating from Oracle to SQL Server 2012

    However, if you have added rowid columns to tables in SQL Server and the error still exists, I recommend you migrate data from oracle11g to SQL Server 2012 using SSIS(SQL Server Integrated Services), for more information about migrating rowid data from oracle11g to SQL Server 2012 using SSIS, please refer to this link: https://www.simple-talk.com/sql/ssis/working-with-ssis-data-types/

    Regards,
    Ice Fan 


    Ice Fan
    TechNet Community Support



    Tuesday, October 13, 2015 1:28 PM

All replies

  • take reference from following link.

    https://social.msdn.microsoft.com/Forums/en-US/09b2efaa-4c18-4f7d-8a45-9d81fe797457/sqlbulkcopy-and-guiduniqueidentifier-columns?forum=adodotnetdataproviders


    Please click "Mark As Answer" if my post helped.

    Tuesday, October 13, 2015 1:00 PM
  • Hi Pramendra,

    According to your description, you get the error” The given value of type String from the data source cannot be converted to type uniqueidentifier of the specified target column” when doing a migration from oracle11g to SQL Server 2012. We need to verify that if you add rowid columns to tables in SQL Server, if not, please set the generate rowid column option to ‘Yes’ or add rowid column for tables with triggers in the SSMA project settings, then check if you can migrate data successfully. For more information of migrating data from Oracle to SQL Server using SSMA(SQL Server Migration Assistant), please refer to this article: Guide to Migrating from Oracle to SQL Server 2012

    However, if you have added rowid columns to tables in SQL Server and the error still exists, I recommend you migrate data from oracle11g to SQL Server 2012 using SSIS(SQL Server Integrated Services), for more information about migrating rowid data from oracle11g to SQL Server 2012 using SSIS, please refer to this link: https://www.simple-talk.com/sql/ssis/working-with-ssis-data-types/

    Regards,
    Ice Fan 


    Ice Fan
    TechNet Community Support



    Tuesday, October 13, 2015 1:28 PM