Start-SqlMigration is like an "easy button" that allows you to migrate one entire instance to another.

Huge update Sept 30, 2015: Start-SqlMigration is now part of a PowerShell module called dbatools. dbatools offers a number of functions for DBAs. Start-SqlMigration, one of the included functions, migrates databases, logins, job server, credentials, linked servers, server triggers, backup devices, Central Management Server, server configurations, database mail and user objects in system databases.

Huge update Dec 1, 2018: dbatools now works on Linux and macOS

Please read for more information.



Start-DbaMigration -Source sql2012 -Destination sql20o17 -BackupRestore -SharedPath \\nas\sql\migration