Azure Data Migration Assistant Blockers

Nilesh Patel 111 Reputation points
2021-11-17T05:24:02.173+00:00

Just a quick overview, I am migrating from on-premise SQL server to Azure SQL managed instance. For assessment using DMA tool and for the migration using DMS tool.

Got some blockers and these are:

  1. Breaking Changes should compulsory change before the migration?
  2. And all the breaking Changes resolved manually in the source target?
  3. Let say I have many number of databases and got lots of breaking Changes how can I do this manually(can't do one by one for so much breaking Changes)?
  4. Behavioral changes does not affect the migration but might affect the performance. So, behavioral changes should resolved before the migration or after the migration?
  5. What are the data types supported in on-premise SQL server (SQL server 2012, SQL server 2016) but not in Azure sql Managed Instance?
  6. If some data types are not supported in our target server then how it will be done. And, does it affect our migration also?
  7. If I am talking about large number of databases so, if many data types are not supported then, it is impossible to change to the compatible data types manually?
  8. I am doing assessment of one server can I do the assessment of other servers(3-4 servers) in parallel in DMA tool?
  9. What are all the comparability level 150,140,140,120,110 ( not able to understand these levels)?

Thanks.

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.
547 questions
{count} vote

Accepted answer
  1. CathyJi-MSFT 22,346 Reputation points Microsoft Vendor
    2021-11-17T07:20:59.59+00:00

    Hi @Nilesh Patel ,

    >What are all the comparability level 150,140,140,120,110 ( not able to understand these levels)

    150----SQL 2019
    140----SQL 2017
    130----SQL 2016
    120----SQL 2014
    110----SQL 2012

    >I am doing assessment of one server can I do the assessment of other servers(3-4 servers) in parallel in DMA tool?

    Yes, you can create multi project for the assessment of other migration as below screenshot. They run in parallel in the DMA tool.

    150027-screenshot-2021-11-17-154658.jpg

    For other questions, I suggest you running DMA for this migration, this tool can perform assessments to identify feature parity and database compatibility issues when moving your SQL Server to Azure SQL managed instance. Such as discovering the compatibility issues, or discovering breaking changes and behavior changes that will effect migration etc. It will present you with a report identifying all those, as well as possible fixes for the different Database Compatibility level available for your chosen target. Refer to MS document Overview of 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".

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,346 Reputation points Microsoft Vendor
    2021-11-19T00:20:22.733+00:00

    Hi @Nilesh Patel ,

    >ou said for the compatability level 150 it's SQL Server 2019. But as you can see in the screenshot that for the SQL Server 2019, I am getting compatability level 130.

    The default compatibility lever of SQL server 2019 is 150. But SQL server 2019 support the compatibility lever values 150, 140, 130, 120, 110, 100.

    150763-screenshot-2021-11-19-081524.jpg

    Refer to this MS document to get more information.


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

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.