Data Migration Assitant 5.5.5310.2 throwing Error Code: 46010 in stored procedures

Chris Wood 21 Reputation points
2022-01-25T23:01:12.757+00:00

I am running the Data Migration Assistant to look at migrating SQL 2019 CU11 databases to the Cloud, probably to Managed Instance because of cross-database queries. I am getting a number of 46010 errors with this message or similar - has syntax errors. Incorrect syntax near -.. Error number 46010.

Using SSMS 18.10 I can script out these stored procedures and add them with new names with no issues.

Chris

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.
495 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-01-26T02:00:55.937+00:00

    Hi @Chris Wood ,

    Suggest you using General Scripts Wizard in SSMS to script out this procedure. Please change the options as below screenshot to make sure you script out all information for this procedure. Then run the scripts with a new name in SQL 2019 or SQL server managed instance, check if any error message occurred? If no error occurred, please share us the scripts of your stored procedure. We can start to troubleshoot this issue from analyzing your scripts.

    168526-screenshot-2022-01-26-100006.jpg
    168527-screenshot-2022-01-26-095033.jpg
    168400-screenshot-2022-01-26-095933.jpg

    If the scripts of stored procedure have no issue, you also want to ignore them in DMA, we can use the ignoreErrorCodes property. You can specify to ignore a single error or multiple errors.

    <workflowSettings>  
      
    <assessment parallelDatabases="8" ignoreErrorCodes="46010" />  
      
    </workflowSettings>  
    

    Refer to MS document Configure settings for Data Migration Assistant.


    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 additional answers

Sort by: Most helpful