How to migrate SQL Server databases to Azure | Microsoft Mechanics

%3CLINGO-SUB%20id%3D%22lingo-sub-1834050%22%20slang%3D%22en-US%22%3EHow%20to%20migrate%20SQL%20Server%20databases%20to%20Azure%20%7C%20Microsoft%20Mechanics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834050%22%20slang%3D%22en-US%22%3ERunning%20SQL%20Server%20on-premises%20and%20looking%20to%20move%20to%20Azure%3F%20Review%20your%20best%20options%20for%20assessment%20and%20migration.%20Bob%20Ward%2C%20SQL%20Server%20database%20expert%20and%20engineering%20lead%2C%20joins%20host%20Jeremy%20Chapman%20to%20walk%20through%20different%20migration%20options%20for%20moving%20your%20SQL%20Databases%20into%20the%20cloud%2C%20and%20then%20shows%20how%20to%20perform%20a%20migration%20end-to-end.%20Whether%20you%20need%20to%20increase%20your%20capacity%2C%20take%20advantage%20of%20built-in%20high%20availability%20in%20disaster%20recovery%2C%20or%20reduce%20your%20operational%20costs%2C%20moving%20to%20Azure%20is%20the%20next%20logical%20step.%20In%20fact%2C%20you%20can%20bring%20your%20existing%20SQL%20licenses%20to%20the%20Cloud%20with%20Azure%20Hybrid%20Benefit.%20And%20with%20that%20benefit%2C%20you%20can%20actually%20bring%20your%20on-premises%20licenses%20into%20Azure%20to%20save%20on%20subscription%20costs%2C%20as%20well.%20Check%20out%20migration%20options%3A%20%E2%80%A2%20Lift%20and%20shift%20your%20SQL%20Servers%20to%20Azure%20VMs%20instead%20of%20your%20own%20infrastructure%20%E2%80%A2%20Migrate%20to%20Azure%20SQL%20Managed%20Instance%2C%20which%20is%20a%20fully-managed%20SQL%20Server%20%E2%80%A2%20Migrate%20to%20Azure%20SQL%20Database%2C%20which%20is%20the%20best%20for%20modern%20database%20applications%20and%20gives%20you%20maximum%20PaaS-managed%20capabilities%20Find%20tools%20to%20migrate%20to%20a%20Managed%20Instance%20or%20to%20Azure%20SQL%20database%3A%20Data%20Migration%20Assistant%20(DMA)%20helps%20detect%20compatibility%20issues%20that%20can%20impact%20database%20functionality%20in%20your%20new%20version%20of%20SQL%20Server%20or%20Azure%20SQL.%20And%20it%20helps%20you%20right-size%20your%20deployment%20for%20the%20appropriate%20Azure%20service%20tier.%20Data%20Migration%20Service%20(DMS)%20gives%20a%20holistic%20view%20of%20your%20data%20state%20after%20your%20initial%20assessment%2C%20and%20is%20used%20for%20live%20migration%20for%20zero%20downtime.%20Link%20References%3A%20Download%20the%20Data%20Migration%20Assistant%20(DMA)%20tool%20for%20free%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FDMAdownload%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FDMAdownload%3C%2FA%3E.%20Learn%20more%20about%20DB%20Compat%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fdbcompat%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fdbcompat%3C%2FA%3E.%20See%20how%20to%20apply%20database%20schemas%20before%20you%20migrate%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FAzureSqlMigrate%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FAzureSqlMigrate%3C%2FA%3E.%20Migrating%20a%20large%20number%20of%20databases%3F%20Go%20to%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FDMAPowerShell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FDMAPowerShell%3C%2FA%3E%20to%20learn%20more.%20Check%20out%20the%20rest%20of%20our%20Azure%20Migration%20series%20at%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FMechanicsAzureMigrate%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2FMechanicsAzureMigrate%3C%2FA%3E.%20If%20you%20are%20unfamiliar%20with%20Microsoft%20Mechanics%2C%20we%20are%20Microsoft%E2%80%99s%20official%20video%20series%20for%20IT.%20You%20can%20watch%20and%20share%20valuable%20content%20and%20demos%20of%20current%20and%20upcoming%20tech%20from%20the%20people%20who%20build%20it%20at%20%23Microsoft.%20Subscribe%20to%20our%20YouTube%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fc%2FMicrosoftMechanicsSeries%3Fsub_confirmation%3D1%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fc%2FMicrosoftMechanicsSeries%3Fsub_confirmation%3D1%3C%2FA%3E%20Follow%20us%20on%20Twitter%3A%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FMSFTMechanics%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftwitter.com%2FMSFTMechanics%3C%2FA%3E%20Follow%20us%20on%20LinkedIn%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft-mechanics%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft-mechanics%2F%3C%2FA%3E%20Follow%20us%20on%20Facebook%3A%20%3CA%20href%3D%22https%3A%2F%2Ffacebook.com%2Fmicrosoftmechanics%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffacebook.com%2Fmicrosoftmechanics%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1834050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EInfrastructure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMigration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Microsoft

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 https://aka.ms/DMAdownload.

Learn more about DB Compat at https://aka.ms/dbcompat.

See how to apply database schemas before you migrate at https://aka.ms/AzureSqlMigrate.

Migrating a large number of databases? Go to https://aka.ms/DMAPowerShell to learn more.

Check out the rest of our Azure Migration series at https://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 YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1

Follow us on Twitter: https://twitter.com/MSFTMechanics

Follow us on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/

Follow us on Facebook: https://facebook.com/microsoftmechanics/

0 Replies

Session Resources