Server migration to a new on-premise platform—are there alternatives to the Data Migration Assistant?

Question

It seems that the Data Migration Assistant is outdated, and Microsoft only offers the SQL Server to Azure option.

Answer 1

Azure Database Migration Service: This tool helps in migrating databases to Azure, but ably assist also with on-premise migrations.

SQL Server Integration Services (SSIS): Very good ETL tool that helps in case of data migrations across various sources and destinations.

Microsoft SQL Server Management Studio (SSMS): Export and import tools are provided as well for the purposes of migration; scripts are also created in the system to facilitate this process.

Third-Party Tools:

Redgate Data Compare: best for comparing and synchronizing SQL Server Database.

Idera SQL Safe Backup: For Data migration and backup efforts can also assist

DBAtools: a PowerShell modify that offers various SQL Server assistant segments, including migration functions.

Manual Scripts: In regards to all the export and import requirements, writing MSSQL scripts can also be a successful method, particularly regarding the more advanced Migratory cases.

Replication Tools: Employing Database replication tools to help with replication of the data during migration tend to come in handy, in this case, the amount of downtime is reduced.

Answer 2

Hi @Tuomas_J ,

Thank you for your reaching out and welcome to Microsoft Q&A!

Could you please tell us what is the basis for your issue? Could you please share the document with us here? We can get the information from the official documentation:

I hope this helps! If you have any more issues or need further assistance, feel free to share with us!

Best regards,

Lucy Chen

---

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.

https://docs.microsoft.com/en-us/answers/support/email-notifications