Simplifying SQL Server Migrations With PowerShell

Presented on May 15, 2015 by Chrissy LeMaire, PowerShell MVP
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 ( Code specifics and current limitations will also be discussed.