SQL Server 2022 migrations with dbatools
summary
Dbatools migrates three demo databases to SQL Server 2022 using commands like copy DBA login (preserves SIDs and SQL password hashes) and copy DBA database with backup/restore or attach/detach. Strategy shows pre-staging with no recovery, then a differential or log backup to cut over (demo timestamps 11:43 → 11:44 to prove parity). Compatibility level is set to 160 (requires latest SMO/dbatools pre-release). Demos and a ready DevContainer are on GitHub; supports backups from 2008 and in-place upgrades from 2012+ if compatibility ≥90.
AI-written summary · about
chapters (4)
related talks
20mSQL Server 2022 migrations with dbatools
50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
01h 37mdbatools for Systems Engineers and Accidental DBAs
44mAnthony's Favorite dbatools cmdlets and Use Cases
39mDatabase DevOps with Containers
21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
50mSQL Modernization Journey with Tools, Assets & Migration Best Practices