SQL Server 2022 migrations with dbatools

on YouTube ↗20m

" summary

Shows a hands‑on migration to SQL Server 2022 using dbatools with runnable demos and a GitHub devcontainer, proving the process works. Uses backup‑restore with no recovery to pre‑stage large databases, then applies a differential or log backup to cut over and minimize downtime (example moves orders from 11:43 to 11:44). Demonstrates copy DBA login that copies SIDs and hashed passwords to avoid orphaned users, notes options for attach/detach and log shipping, and sets compatibility to 160 via set‑DBACompatibility.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 2:23Migrating to SQL Server 2022 - How?
3. 4:58Demo Time
4. 17:17Questions & Feedback

" related talks

• 44mMy romantic relation with Powershell generally and DBATools especiallyMagnus Ahlkvist · SQL Server Virtual Conference 2021
• 46mLift and Shift with dbatools - Azure SQL Managed Instance editionCLÁUDIO SILVA · SQLBits 2023
• 44mAnthony's Favorite dbatools cmdlets and Use CasesAnthony Nocentino · PowerShell + DevOps Global Summit 2023
• 36mSQL Server Configuration with dbatools & dbachecksTracy Boggiano · SQL Server Virtual Conference 2021
• 39mDatabase DevOps with ContainersRob Richardson · Data Con LA 2021
• 01h 00mLet's Get Scary and Continuously Deploy Database Changes!Dan Mallott · NDC Oslo 2023
• 50mBringing DevOps to the DatabaseSteve Jones · SQL Server Virtual Conference 2021
• 23mShift-Left: A DevOps and Database StoryKevin Kline · SQLBits 2022