on-promise Oracle to azure sql via SSMA too many errors

Yang, Henry-D 1 Reputation point
2021-06-02T13:01:49.093+00:00

we using SSMA migrate oracle schema to Azure sql, but there has too many errors, any idea to fixes these error quickly
101732-capture.png

Azure Database Migration service

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
    2021-06-03T19:24:10.407+00:00

    Hi @Yang, Henry-D 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:

    102107-image.png

    Regards,
    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.