Managing replication with dbatools
summary
dbatools adds new replication commands to a ~700-command PowerShell module allowing enablement of a distributor, creation of snapshot, transactional, merge publications, adding articles (including row filters), and creating push or pull subscriptions. Demo shows using Get/New/Add/Remove-style cmdlets to run snapshot and log‑reader agents, inspect replication monitor output, verify filtered rows arrive on a subscriber, and tear everything down. Demo files and Docker setups live on GitHub for reproduction and filing issues.
AI-written summary · about
chapters (8)
- 0:00Introduction and background
- 1:44Overview of DBAtools
- 4:25SQL replication concepts
- 11:00Replication commands
- 13:00Live demo: setting it up
- 28:43Verifying replication
- 33:30Cleaning up the environment
- 38:49Q&A and final resources
related talks
48mManaging replication with dbatools
44mAnthony's Favorite dbatools cmdlets and Use Cases
44mMy romantic relation with Powershell generally and DBATools especially
36mSQL Server Configuration with dbatools & dbachecks
44mContinuously deploying SQL code using Powershell
20mSQL Server 2022 migrations with dbatools
46mLift and Shift with dbatools - Azure SQL Managed Instance edition
47mAutomating Active Directory Health Checks