Migration-Party

Real-World TDE Database Migrations

In today’s post, I will tell you about how we managed to successfully complete a migration during a ~12 hour maintenance window. This could have taken a LOT longer if we didn’t have dbatools to automate several of the steps. Although I will not go in to every detail about our process, I want to emphasize the areas were we chose to use dbatools to make our lives easier. The Goal Recently, we got the green light for upgrading to SQL Server 2016 and we were ready to roll.