How to migrate SQL Server databases to Azure

Running SQL Server on-premises and looking to move to Azure? Review your best options for assessment and migration. Bob Ward, SQL Server database expert and engineering lead, joins host Jeremy Chapman to walk through different migration options for moving your SQL Databases into the cloud, and then shows how to perform a migration end-to-end.
Whether you need to increase your capacity, take advantage of built-in high availability in disaster recovery, or reduce your operational costs, moving to Azure is the next logical step. In fact, you can bring your existing SQL licenses to the Cloud with Azure Hybrid Benefit. And with that benefit, you can actually bring your on-premises licenses into Azure to save on subscription costs, as well.
Check out migration options:
• Lift and shift your SQL Servers to Azure VMs instead of your own infrastructure
• Migrate to Azure SQL Managed Instance, which is a fully-managed SQL Server
• Migrate to Azure SQL Database, which is the best for modern database applications and gives you maximum PaaS-managed capabilities
Find tools to migrate to a Managed Instance or to Azure SQL database:
Data Migration Assistant (DMA) helps detect compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL. And it helps you right-size your deployment for the appropriate Azure service tier.
Data Migration Service (DMS) gives a holistic view of your data state after your initial assessment, and is used for live migration for zero downtime.
Link References:
Download the Data Migration Assistant (DMA) tool for free at aka.ms/DMAdownload.
Learn more about DB Compat at aka.ms/dbcompat.
See how to apply database schemas before you migrate at aka.ms/AzureSqlMigrate.
Migrating a large number of databases? Go to aka.ms/DMAPowerShell to learn more.
Check out the rest of our Azure Migration series at aka.ms/MechanicsAzureMigrate.
If you are unfamiliar with Microsoft Mechanics, we are Microsoft’s official video series for IT. You can watch and share valuable content and demos of current and upcoming tech from the people who build it at #Microsoft.
Subscribe to our KZbin: kzbin.info...
Follow us on Twitter: / msftmechanics
Follow us on LinkedIn: / microsoft-mechanics
Follow us on Facebook: / microsoftmechanics
#Azure #SQLserver

[@KillaDBA]

Great video! Bob Ward helped me write a couple of songs about SQL Server (SQL Server 2022 and SQL 30 on Windows) #KillaDBA 🙂

[@rishi2791]

Good stuff man !!

[@fabiofmaia2011]

Hello! Can I migrate my sql server DBs on promises to Azure data lake gen 2 sql pool serverless using BCP? I would like to store directly in the containers... if it’s possible, where can I find this documentation how to do that? Thanks in advance!

[@erik9817]

Is it possible to move a SQL Server Express to Azure SQL Database or something else on Azure?

[@passiontri4164]

Is this the safest way of migration?

[@aks541]

Honestly speaking from this video can't understand the difference between VM based SQL server and SQL Server Managed instance? I know the difference between Azure SQL DB which is a PaaS but can't get how SQL Server Managed instance is also a PaaS

[@MSFTMechanics]

With Managed Instance, you basically get compatibility and cross db communication like you would in a virtual machine, but you don't need to manage a virtual machine. No operating system updates, machine policy and configuration, etc. Its just the SQL Server instance.