Share via

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 21,126 Reputation points Microsoft Employee Moderator
    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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.