15 Performing your first advanced SQL Server instance migration, part 1

Within the SQL Server community, simplified migrations sparked wide adoption of not just dbatools but PowerShell as well. The videos showing instance-to-instance migrations, such as sqlps.io/instmigration, resonated with DBAs. This video revolved around our flagship command, Start-DbaMigration, which migrates one entire SQL Server instance to another and can be as straightforward as the code seen in the next listing.

Listing 15.1 Using Start-DbaMigration to migrate one instance to another

PS> Start-DbaMigration -Source sql01 -Destination sql02 -BackupRestore
 -SharedPath \\nas\sql\migration

This command wraps a bunch of other Copy-Dba* commands and simplifies a complex process ...

Get Learn dbatools in a Month of Lunches now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.