1

There's a breaking change being highlighted in the Data Migration Assistant tool Syntax issue on the source server about the syntax of an object however I am unable to find this object.

I've searched in sys.objects, the Object Explorer Details in SSMS & using RedGate SQL Search but can't find an object with this name.

I've added details below -

  • Database Compatability: 100 (2008) to 150 (2019) (The breaking change shows from combability 100 onwards through DMA)

  • Object: 'DatabaseName'_DB_MGMT_SPEC

The errors from DMA -

While parsing the schema on the source database, one or more syntax issues were found. Syntax issues on the source database indicate that some objects contain unsupported syntax due to which all assessment rules were not run on the object.

Object ['DBName'_DB_MGMT_SPEC] has syntax errors. Incorrect syntax near ].. Error number 46010. For more details, please see: Line 2, Column 23.

I found this similar issue but no solution https://social.msdn.microsoft.com/Forums/en-US/4f9d9330-2e91-454e-b97d-7d4272e1e109/need-to-identify-object-mentioned-in-data-migration-assistant-for-sql-server-upgrade-from-2008r2-to?forum=sqlservermigration

Improve this question
0

1 Answer 1

Reset to default
1

Found the issue, there are Database Audit Specifications that appear not to have been set up properly with the 'DatabaseName'_DB_MGMT_SPEC name, removing these removed the warnings from DMA

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.