Imagine migrating SQL Server databases, logins, jobs, operators, and other SQL Server components with just a single command; this is what PowerShell can do for you. In this session, I'll discuss the reasons DBA's migrate SQL Server instances, some of the tools and techniques that are used, and the objects that are most commonly migrated, along with considerations that must be made for each. Then, I'll perform a few migrations using PowerShell scripts available within my sqlmigration repository on github (https://github.com/ctrlbold/sqlmigration). Code specifics and current limitations will also be discussed.
I have worked in IT for nearly 20 years, and currently serve as the SQL Server DBA for NATO Special Ops in Belgium. I'm also an avid scripter, and have used PowerShell since I was first introduced to Monad in 2005 at the Microsoft PDC in Los Angeles.
I'm currently pursuing an MS in Systems Engineering at Regis University. In my spare time, I explore Trappist breweries in Belgium with my wife and maintain RealCajunRecipes.com with my mom and best friend.