2019 04 09 Migrate Your Databases with Distributed AGs by Elizabeth Noble

Have you found yourself needing to migrate to new hardware or a new operating system? If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want. In this session I will explain the purpose and usages of Distributed AGs, how to create a Distributed AG and the associated AGs, and how to perform a mock data center migration. NOTE: This session expects that attendees are already familiar with Availability Groups.
Elizabeth Noble is a Database Engineer in the metro Atlanta area. When she was introduced to her first database over 10 years ago, it was love at first sight. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all of the things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.

[@patricksneed8107]

FYI, make sure to enable trace flag 1800. We ran into issues on this

[@shamilsaleem9444]

is a distributed AG a recommended DR approach for production ?

[@ashifshaikh2763]

it depends on your requirement mainly whether you need a read-only replica