Lets Import the Sample Database in the SQL Server

• Launch SQL Server Management Studio
  
• Dowload a Sample Server Backup of Adventure Works for 2019 Refer Here
• Restore Backup
  
  
• Database Migration Approaches
• Offline Migration:
  • You take the backup of existing database to some file
  • Take downtime for your databases (so that there are no further changes.)
  • Upload the backup to the cloud and create an Azure SQL Database with the imported back up.
• Online Migration:
  
• Refer Here for different options of migrations
• In this scenario we would want to Migrate from SQL Server 2019 to Azure SQL Database
• Refer Here for the official docs to migrate to Azure SQL

Lets Start Database Migration

• Create a Azure Migrate Project
  
  
  
  
• Install the Database Migration Assistant (DMA) Refer Here
• If required download .net framework 4.8
• Start the DMA & Create a new project
  
  
  
  
  
  
  
• Now we have a local assesment report and we need to upload the report to azure migrate but facing the issue
  
• Lets resolve this in our next session.