Data Migration Assistant analysis

Question

Hi Team,

I had a question related to Feature parity report of Data Migration Assistant tool, in output of this report I see that there is mention of SQL Server agent jobs. We are generating this report, after selecting a database, than why there is a mention of SQL Server agent jobs when SQL Server agent jobs are outside of the Database. As per my understanding through this report we are basically analyzing how much compatible the Database is as compared to the target sql server type (Azure SQL DB or Azure SQL Managed Instance), so why there is mention of an object, sql server agent jobs which are outside of the database? Please let me know the reason.

Thanks,
Salil

Answer 1

With the parity check, DMA tries to discover unsupported or partially-unsupported features and functions. Although you are performing an assessment of the database you plan to migrate to Azure SQL Database, DMA warns about the database possibly being used on current SQL Server jobs. If the database is used on SQL Server agent jobs, you may need to reengineer the jobs and use Azure Elastic Jobs or Azure Automation to achieve the same.

Azure SQL Managed instance does support SQL Agent jobs as explained here.

Answer 2

Hi @salilsingh-9961 ,

Please check out this article:

Release: Data Migration Assistant (DMA) v4.3

It mentions DMA support for
Agent job assessments for Azure SQL Database managed instance as a target.
Assessment of T-SQL queries in job activity steps and providing appropriate recommendations

And also mentioned is support for Agent job, so you can see the related report

-------------

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.