we using SSMA migrate oracle schema to Azure sql, but there has too many errors, any idea to fixes these error quickly
we using SSMA migrate oracle schema to Azure sql, but there has too many errors, any idea to fixes these error quickly
Hi @YangHenryD-9047 We are investigating the issues you posted above. I will let you know if i need any info from you. Thank you for your patience
Regards,
Oury
Hi @YangHenryD-9047 This is by design and not the problem with the tool. Not everything can be converted automatically, some of the statements need to be addressed manually and SSMA produces a “conversion error” to indicate the need for manual intervention. It is not a bug or an error in the tool.
Most of them the errors are in the EXECUTE IMMEDIATE bucket. There are natural limitations around this statement where SSMA simply cannot translate these statements. You can extract these statements and translate them using statements conversion feature in SSMA:

Regards,
Oury
Hi @YangHenryD-9047 Please let us know if you need more assistance.
Regards
Oury
5 people are following this question.
What source/target pairs does Azure Database Migration Service currently support?
Migration from IAAS to Hyperscale on Azure
Moving 7TB of data from Azure IAAS database to Hyperscale
List of required allowed services, allowed resource types and allowed permissions for SAS
how to replicate ongoing changes of on prem database to data lake?