question

YangHenryD-9047 avatar image
0 Votes"
YangHenryD-9047 asked OuryBa-MSFT commented

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

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
capture.png (211.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered OuryBa-MSFT commented

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:

102107-image.png



Regards,
Oury


image.png (23.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @YangHenryD-9047 Just checking if you have further query.
Regards
Oury

0 Votes 0 ·

Hi @YangHenryD-9047 Please let us know if you need more assistance.
Regards
Oury

0 Votes 0 ·