Information
You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.
Learning objectives
In this module, you'll:
- Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
- Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
- Use transactional replication as an online method to migrate to Azure SQL Database.
- Explore several other methods for migrating SQL Server databases to Azure SQL Database.
Prerequisites
- Experience in administering SQL Server databases.
- Knowledge of SQL Server editions and versions.
- Knowledge of basic T-SQL.
Modules
- Introduction
- Choose the right Azure SQL Database feature
- Use Azure SQL migration extension to migrate to Azure SQL Database
- Explore Data Migration Assistant to migrate to Azure SQL Database
- Migrate to Azure SQL Database using BACPAC
- Use an online method to migrate to Azure SQL Database
- Move data to Azure SQL Database
- Exercise - Migrate a SQL Server database to Azure SQL Database
- Knowledge check
- Summary
null
