M2SS0198 : SSMA for MySQL does not support user variables conversion

cc 1 Reputation point
2022-01-18T10:50:54.673+00:00

Hi,
I'm trying to convert a very big MySQL db to MS SQL by SSMA.
in the report I see this error (M2SS0198 : SSMA for MySQL does not support user variables conversion) 96 times...
it's caused by MySQL user variable that begin with @, what I write without declare in the proc header.
MS SQL doesnt support undeclared variable.
Is there a way to convert it automatically ?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-01-19T05:58:58.47+00:00

    Hi @cc ,

    What version of SSMA that you are using? Suggest you using the latest version SSMA for MySQL 8.24. It does not make sure this will resolve your issue.

    You can try to use SSIS. There are some limitations and there are some scenarios where it is not possible to migrate all the tables using SSMA. In such cases, you can try to use SSIS to complete the migration of the non-compatible tables. Please refer to this blog How to migrate MySQL tables to SQL Server using the SQL Server Migration Assistant (SSMA) and SSIS to get detail steps.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments