July 2018
Beginner
552 pages
13h 18m
English
Facilitating SQL migrations is the original objective of dbatools. All 31 migration commands (number subject to change) operate on the same defaults/many options principle, allowing simple use in most instances, but offering good control for borderline cases:
Copy-DbaLogin -Source sql2000 -Destination sql2017
The preceding example will copy all logins from the sql2000 instance to the sql2017 instance, and will not need much adjustment in most instances.
Rather than a single subset of items, it is even possible to migrate an entire instance from an old SQL server installation to a new one, as follows:
Start-DbaMigration -Source sqlserver\instance -Destination sqlcluster -DetachAttach
This single line is all it takes to ...
Read now
Unlock full access