Interview Questions How to Resolve and Fix Microsoft Data Migration Assistant (DMA) Crash January 3, 20223 views0 Share By IG Share This article will explain how to fix Microsoft Data Migration Assistance in case it crashes during the assessment or migration phase. What is Microsoft Data Migration Assistant? The Data Migration Assistant (DMA) helps you elevate to a modern data platform by catching compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL (DB) Database. DMA guides performance and reliability improvements for your target environment and permits you to move your schema, data, and uncontained objects from your source server to your target server. How to Resolve and Fix Microsoft Data Migration Assistant (DMA)? The tool is robust and works well with smaller databases. But, how small is small? The official Microsoft documentation does not have a hard number. However, based on our experience, we reckon it should not be more than 200 GBs. Experiences may vary based on scenarios. While using the tool, we learned several techniques to get around the crashing problems. We hope to get a permanent fix from Microsoft since it is an excellent tool for migration scenarios. For migrating a large number of databases and bigger DB sizes, use the Azure Database Migration Service. For migrations to Azure SQL Managed Instance, use the Azure SQL Migration extension for Azure Data Studio since the DMA does not support it. Run the DMA tool in single-user mode as shown below: Open Task Manager>Details>WMA.exe. See screenshot below: Select only 1 CPU and run your project assessment to check if it resolved the problem. WorkflowHostProgram.Win has stopped working, as see in the following screenshot: The WorkflowHostProgram.Win is the parent process of WMA.exe, and when it crashes, it shows up as “Not Responding” or “Close the Program” Apart from running the program in single-user mode, check if your memory or CPU utilization is high. Conclusion We hope this post was helpful. We will update this post once we have more steps or options to troubleshoot. Your feedback and suggestions are welcome in the comment box below. Thanks for visiting. Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
Interview Questions Comparing Google Workspace vs M365 Microsoft 365 Business vs Enterprise By IGMarch 20, 2021
Interview Questions How to Disable Bluetooth on Startup on Ubuntu Linux OS by Default By DasMay 17, 2020
Interview Questions How to get the ACTUAL version number of Windows 10 from command line? Windows 10 is the latest operating system from Microsoft. Ever since Windows has moved to ...
Interview Questions How to open a folder from Windows Explorer in Command Prompt under Windows 10 with a shortcut? For Windows power users, the ‘Command Prompt’ is one of the extended options you would ...
Interview Questions How to Manually Edit the Right Click Menu on Windows 10 Step by Step If you are looking to change the default settings and edit the right click menu ...
Interview Questions How to Use Windows Media Creation Tool For Windows 10 to USB The Windows Media Creation Tool is an excellent option for installing your Windows 10. You ...