Lift and Shift with dbatools - Azure SQL Managed Instance edition

on YouTube ↗46m

" summary

dbatools (650+ commands) automates lift‑and‑shift from on‑prem SQL Server 2022 to Azure SQL Managed Instance using PowerShell: create managed identity for blob access instead of SAS, add Storage Blob Data Contributor role, run Backup‑DbaDatabase to Azure and Restore‑DbaDatabase into MI (backups must be copy only), or automate online migration by provisioning a distributed availability group (MI link) and performing a safe failover; demos succeed but require extra Azure role assignments, Azure modules and occasional connection tweaks (MARS / permissions).

AI-written summary · about

" chapters (7)

1. 0:00dbatools and Azure SQL MI
2. 7:55SQL credential management
3. 15:28Offline migration to Azure SQL MI
4. 24:49Backup and restore between MI and on-prem
5. 36:25Round-trip migration and verification
6. 37:30Automating MI Link setup
7. 46:08Closing and Q&A

" related talks

• 44mAnthony's Favorite dbatools cmdlets and Use CasesAnthony Nocentino · PowerShell + DevOps Global Summit 2023
• 20mSQL Server 2022 migrations with dbatoolsJess Pomfret · SQLBits 2019
• 44mMy romantic relation with Powershell generally and DBATools especiallyMagnus Ahlkvist · SQL Server Virtual Conference 2021
• 01h 00mLet's Get Scary and Continuously Deploy Database Changes!Dan Mallott · NDC Oslo 2023
• 36mSQL Server Configuration with dbatools & dbachecksTracy Boggiano · SQL Server Virtual Conference 2021
• 22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud CockpitBen Weissman · SQLBits 2024
• 49mSQL Server and Windows Server Better together on AzureBob Ward, Dilip Ramachandran · SQLBits 2022
• 01h 05mCreating Azure SQL Database Users Programmatically using Azure DevOpsRob Sewell · Global Azure 2021