On Prem To The Cloud: Migrating to Azure SQL (episode 7)

Our customers have been wanting some more basic, getting started material on taking their on prem applications and moving them to the cloud. This video series does just that. Starting with a simple on prem solution, lifting and shifting and slowly evolving the app through its many stages until it is a 100% cloud native app. On Episode 7 we will dive into our database solution and explore using a Platform as a Service (PaaS) offering.

Jump to:
[02:45] Azure SQL Deployment Options
[06:02] Azure Database Migration Service
[12:27] Database Migration Assistant

Learn more:

DevOps Lab favorites:

[MehrdadAlemi]

One important thing to pay attention to is the SQL Agent, SQL Login, and database Security Users that we need to move them over as well! Also, ENT databases have some associated SSIS Jobs to run on a schedule too. So, how we should transfer them too? and also if we add a related SSRS reports I think just around the database migration you need to create a 5 or 6 part video series!