Share via

SQL Data Migration Assistant

Urbel 460 Reputation points
2026-02-24T02:22:42.8133333+00:00

Hi all,

why DMA V5.8 tools has no choice for target Platform SQL server On Prem, only SQL Azure to select..

what's your solution for SQL Server On Prem Paltform?

thanks for all reply

regards,

UrBel

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.

0 comments
Answer accepted by question author
  1. Akhil Gajavelly 1,560 Reputation points Microsoft External Staff Moderator
    2026-02-24T04:02:18.7466667+00:00

    Hi @Urbel ,

    Yes, if the target is SQL Server On-Prem - SQL Server On-Prem, DMA 5.8 is not really needed. That version is mainly focused on Azure migrations.

    For on-prem migration, use this simple and fully supported method: Follow the bellow steps,

    1. Install the new SQL Server.
    2. Take Full Backup from old server.
    3. Restore it on the new server.
    4. Set the correct compatibility level.
    5. Test the application.

    If you only need upgrade compatibility check, use DMA in Assessment mode or install an older DMA version that supports SQL Server target.

    Thanks,
    Akhil.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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