Fix for the problem with Database Migration Assistant
- Create a new user in Azure Active Directory
- Give this user permissions at subscription level
- Use this user in Database Migration Assistant
- Create an assessment report as we did in our last session
- Then Navigate to Azure Migrate project to look at assessment
- Refer Here for the steps to migrated from SQL Server On-prem to Azure SQL
- Lets Migrate using Azure Database Migration Assistant
- To Create Azure SQL Db Refer Here
- Create an Azure SQL DB
- Now establish connection in DMA & Continue with migration steps
- Now launch SSMS and execute queries to find the count of records in local db
select COUNT(*) FROM Person.Person;
select COUNT(*) FROM HumanResources.Department;
/* Try to count all the other tables*/
* Now connect to the query editor and enter credentials
* There is two more ways to migrate to Azure SQL Using Azure Data Studio.
* Before exploring that, lets delete the Azure SQL Database which we have created
- The Next Steps will be based on Azure Database Migration Service
- Install Azure Data Studio Refer Here
- Install the Azure SQL Migration Extension in Azure Data Studio
- Next Steps:
- We will discuss the migration to Azure SQL Managed Instance & Azure SQL VM
- Also online and offline approaches