~/talk

SQL Server 2022 migrations with dbatools

on YouTube 20m
Talkat SQLBits 2023 · 2023-03-14..03-18· [databases]

speaker

name:Jess Pomfret
links:none on file

resources

video:https://youtu.be/n7_ffbywxr8
slides:none on file

summary

dbatools migrates databases and logins to SQL Server 2022 using concrete steps: copy DBA login transfers SIDs and hashed passwords so logins aren’t orphaned, copy DBA database supports backup/restore, attach/detach, or log shipping, and a no recovery pre-stage plus differential/log backups minimizes downtime. Demo runs in a devcontainer, forces compatibility level to 160 (needs latest SMO and prerelease module), and validates data parity by comparing last order timestamps (11:43→11:44) after cutover, showing the method works end-to-end.

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

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.