Azure Classroomnotes 04/Jun/2023

Database Migration

• Azure has Database migration services to perform Database Migrations.
• Database migrations can be perfomed
  • offline:
    • Taking a backup (Export)
    • Import the data into cloud (Restore)
  • online: Connected transfer
• Azure Database migration by default supports Microsoft sql server and for other database we need to register an extra provider

Migrating mysql to Azure SQL for mysql

• Refer Here

Migrating Microsoft SQL Server to Azure SQL

• Ensure you have connectivity with source and target
• Create a migration project and use Database Migration Assistant to help in guided migration
• For steps follow classroom recordings.