SQL Server Assessment tool

Hi Urbel,

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further

Thanks,

Lakshmi.

Thanks Marcin,

unfortunately no option for SQL OnPrem to SQL OnPrem ..

thanks

UrBel

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