Managing replication with dbatools

on YouTube ↗48m

" summary

dbatools now includes dbatools replication commands that create a distributor and three publications (transactional, merge, snapshot), add articles (SalesLT.Customer with filtered article last name = Gates, Products, Address), and create push subscriptions to a second instance; snapshot, log reader and merge agents run and a newly inserted “Bill Gates” row replicates successfully. Commands also remove subscriptions/articles/publications and support automation with Confirm = $false. Monitoring features and a small disable-publisher bug remain open; demo scripts and Docker-ready samples live on the project GitHub.

AI-written summary · about

" chapters (8)

1. 0:00Introduction and background
2. 1:44Overview of DBAtools
3. 4:25SQL replication concepts
4. 11:00Replication commands
5. 13:00Live demo: setting it up
6. 28:43Verifying replication
7. 33:30Cleaning up the environment
8. 38:49Q&A and final resources

" related talks

• 48mManaging replication with dbatoolsJess Pomfret · SQLBits 2024
• 44mAnthony's Favorite dbatools cmdlets and Use CasesAnthony Nocentino · PowerShell + DevOps Global Summit 2023
• 44mMy romantic relation with Powershell generally and DBATools especiallyMagnus Ahlkvist · SQL Server Virtual Conference 2021
• 56mLogical Replication of DDLsPeter Smith, Zheng Li (Zane) · PGCon 2023
• 20mSQL Server 2022 migrations with dbatoolsJess Pomfret · SQLBits 2019
• 36mSQL Server Configuration with dbatools & dbachecksTracy Boggiano · SQL Server Virtual Conference 2021
• 01h 19mBuilding an Efficient Replication System for Thousands of TerminalsAnton Moldovan · Highload fwdays'20
• 46mLift and Shift with dbatools - Azure SQL Managed Instance editionCLÁUDIO SILVA · SQLBits 2023