SQL Server Assessment tool

It would be helpful if you stated this in your original question.

Microsoft provides tools like the Data Migration Assistant (DMA), which is often thought of in the context of migrating to Azure, but it works perfectly for assessing on-prem to on-prem migrations. DMA can analyze schema compatibility, detect deprecated features, suggest remediation steps, and optionally generate scripts to move schema and data. Another option is SQL Server Management Studio (SSMS) for scripting out databases and jobs, or using Backup/Restore or Detach/Attach workflows. If the database is large or highly transactional, Log Shipping, Database Mirroring, or Always On Availability Groups can be used for minimal downtime migrations.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Refer to https://dori-uw-1.kuma-moon.com/en-us/azure/migrate/concepts-azure-sql-assessment-calculation?view=migrate

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin