Hi everyone,

I got an error when I tried to migrate data from Oracle to SQL Server using SSMA 2012.

There is an error occurred while migrating data from Oracle to SQL Server. The error is mentioned as below:

Unsupported Oracle data type USERDEFINED encountered.

Could you please give me any advices to solve this error?

Thank you.

Regards,

Rosetia

Hi Rosetia,

According to the error message, it seems that User Defined Type(UDT) exists on your Oracle database. UDT that includes object type and collection is not supported in SQL Server and SSMA does not support conversion of Oracle UDT.

To solve this issue, you may consider using SQL Server TVP when migrating your Oracle database to SQL Server. For more details, you can  review the scenarios of UDT and examples on how to recreate the statements in SQL Server from this blog.

There is also a whitepaper about how to migrate Oracle to SQL Server 2012 for your reference.


Thanks,
Lydia