Azure Classroomnotes 09/Jan/2022

Fix for the problem with Database Migration Assistant

  • Create a new user in Azure Active Directory
    Preview
    Preview
    Preview
  • Give this user permissions at subscription level
    Preview
    Preview
    Preview
    Preview
  • Use this user in Database Migration Assistant
  • Create an assessment report as we did in our last session
    Preview
  • Then Navigate to Azure Migrate project to look at assessment
    Preview
    Preview
  • Refer Here for the steps to migrated from SQL Server On-prem to Azure SQL
  • Lets Migrate using Azure Database Migration Assistant
    Preview
    Preview
    Preview
  • To Create Azure SQL Db Refer Here
  • Create an Azure SQL DB
    Preview
  • Now establish connection in DMA & Continue with migration steps
    Preview
    Preview
    Preview
    Preview
    Preview
    Preview
  • 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*/

Preview
* Now connect to the query editor and enter credentials
Preview
Preview
* 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
Preview

  • The Next Steps will be based on Azure Database Migration Service
    Preview
    Preview
    Preview
  • Install Azure Data Studio Refer Here
  • Install the Azure SQL Migration Extension in Azure Data Studio
    Preview
    Preview
  • Next Steps:
  • We will discuss the migration to Azure SQL Managed Instance & Azure SQL VM
  • Also online and offline approaches

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About continuous learner

devops & cloud enthusiastic learner