Managing replication with dbatools
summary
dbatools now includes replication commands that use RMO to enable-distributor and enable-publisher, create or remove publications, add/remove articles (including add-article with filter for row-level filters), and create push subscriptions. Demos build snapshot, transactional and merge pubs, run snapshot/logreader/merge agents, show replication monitor, and prove a filtered row (LastName='Gates') replicates. Commands return rich PowerShell objects, support piping and scripting, and can tear down the full hierarchy; monitoring features and some edge-case bugs are still being worked on.
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
50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights- 50mUnlocking Database Automation with dbatools: Practical Use Cases and Real-World Insights
44mAnthony's Favorite dbatools cmdlets and Use Cases
01h 37mdbatools for Systems Engineers and Accidental DBAs
24mDatabases beyond the tutorials
56mLogical Replication of DDLs
20mSQL Server 2022 migrations with dbatools
53mThe journey towards active replication in PostgreSQL