Reviews 4,2
Reviews 4,5
DP-3001 Migrate SQL Server workload to Azure SQL
Moving SQL Server environments to the cloud is one of the most strategically significant tasks in modern IT infrastructure projects. This course shows how this transition can be planned, secured, and sustained – with Azure SQL as a stable foundation for future data platforms.
Key topics
- Migration approaches and tools for transitioning to Azure SQL
- Architecture variants, deployment models, and operational concepts
- Security mechanisms, availability, and performance optimization
- Data integrity, governance requirements, and compliance
- Monitoring, automation, and cost transparency in ongoing operations
Prerequisite
Solid knowledge of relational databases and hands-on experience with SQL Server are required. Familiarity with cloud and network architectures is helpful.
Target group
Aimed at IT professionals, database administrators, and architects responsible for migrating, operating, and developing data platforms.
A structured entry into Azure SQL lays the groundwork for maintainable, scalable, and future-proof data solutions – with clear attention to security requirements, efficiency, and cloud readiness.
- Analyzing requirements for the target data platform
- Planning migration steps in a structured approach
- Selecting and evaluating suitable migration tools
- Checking compatibility of existing databases
- Comparing and evaluating migration options
- Deploying and assessing the Azure Migration Extension
- Running database assessments with Azure Migrate
- Using the Data Migration Assistant effectively
- Exploring available PaaS services for SQL Server in Azure
- Setting up and operating a single Azure SQL Database
- Using elastic database pools for flexible capacity
- Azure SQL Hyperscale for highly scalable scenarios
- SQL Managed Instance as a fully managed option
- SQL Edge for edge computing scenarios
- Integrating Active Directory and Microsoft Entra ID
- Managing authentication methods and identities
- Applying security policies and principles
- Configuring database and object permissions
- Analyzing and resolving authentication errors
- Selecting the right Azure SQL database feature
- Using the Azure SQL Migration Extension
- Applying the Data Migration Assistant for migration
- Using BACPAC files for database migration
- Online migration method for minimal downtime
- Planning and executing data movement
- Transferring SQL logins and database groups
- Setting up security measures for Azure SQL
- Implementing compliance controls for sensitive data
- Continuously monitoring database performance
- Configuring high availability and disaster recovery
- Automating and scaling database tasks
