Migrations made easy

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 sqlserverinstance -Destination sqlcluster -DetachAttach

This single line is all it takes to handle most default scenarios (and it will notify the user if anything failed).

For more information on dbatools, visit:

https://dbatools.io
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.21.158.148