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

Question

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

Answer 1

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.

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".