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