Data Migration Assistant || Part 4 || Migrate Onpremise SQL to Azure || Ms Azure

The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database.
Microsoft Data Migration Assistant
Download link: www.microsoft....
To run an assessment, you have to be a member of the SQL Server sysadmin role.
docs.microsoft...
Document on DMA : docs.microsoft...

[@chrisumali9841]

Thanks for the demo, and info. Have a great day

[@funnyvamsi4008]

Thank you very much 👍

[@lokeshparvathaneni5275]

Thanks alot. I am learning from you. Thank you so much 👍👍👍

[@vibhaskashyap8247]

I have requirement of SQL Server DB (On-Prem) migration to Azure SQL DB. Based on your tutorial in DMA I can create Migration Project which can create script for schema and data for Dev environment (On-Prem) and can be deployed on Azure SQL DB (Dev environment). In order to do Integration testing should I create a new migration project to move on-prem schema and data in (QA) to Azure SQL DB (QA) ? Do I need to repeat this step for production environment as well ? Please provide some guideline. Need urgent help as I need to estimate the efforts for data migration for DEV, QA and PROD environment. Should I consider data migration effort once or three times for each environment ? Appreciate your quick help in this regard. Thanks

[@righttolearnbk]

Here in Azure portal, you will create single migration project. In DMA tool, project name will be different as the assessment will be done separately for QA, DEV & PROD because you will select individual instance for all these three environments. You can upload all the three assessment results in a single migration project in Azure portal.

[@vibhaskashyap8247]

@@righttolearnbk Thanks a lot for your quick response. Can you please help with clarification on some additional points. 1. Requirement is that Azure SQL DB (DEV) environment to have data from SQL DB On-Prem (Dev). Likewise for QA and Prod environment SQL Server data needs to be mapped to corresponding Azure SQL DB QA and Production environment respectively. This is primarily for regulatory compliance. Does it mean that development effort and data migration efforts I need to consider for each environment separately ? Does effort made to move on-prem DEV environment data reduces effort for QA and PROD ? QA and PROD will surely have higher volume of data. 2. How much typically it takes to migrate 1 TB of data through DMS? Should we consider ExpressRoute if data is more than 1 TB ? 3. Does migration approach changes if target DB is Azure SQL DB or Azure SQL Managed Instance ? 4. Does DMA and DMS migration service support data migration from MySQL (On-Prem) to Azure SQL DB and Azure SQL Managed DB Instance? If you could share some documentation around it will be great help. Thanks

[@righttolearnbk]

@@vibhaskashyap8247 1.Efforts will be same if you have data same in all the three environments otherwise it will be increase with amount of data. 2. Using DMS you can have offline migration if more downtime is accepted or you can go with Online migration. The time of migration depends on various factors Typically it takes 5-6hrs for 1TB data in offline migration. Alternatively you can also use expressroute. 3. Migration approach is almost similar, you will only change the target type. 4. You can use SQL migration assistant Browse through Microsoft website and you will get documentation of all the products and services.

[@dollardreams5811]

How much time it will be take to migrate 1tb database from on premise to azure SQL db

[@righttolearnbk]

Generally it takes 5-6hrs. You can use Azure Data Migration service for online migration to have minimal or no downtime

[@dollardreams5811]

@@righttolearnbk Thank you so much sir