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.
