Recently I found myself responsible for a large database migration and knew I would need to make sure that the environment had the exact same setup as the previous systems and was setup and migrated as fast and as accurately as possible. As a Result I discovered dbatools (https://dbatools.io) which is a PowerShell module that provides some neat cmdlets for SQL Administration. This module can be installed on any recent version of PowerShell (v 4 and v5) from the PowerShell gallery via Find-module and Install-module.

The most helpful of the over 150 cmdlets are the following

1. Copy-SqlLogin
2. Copy-SqlCredential
3. Copy-SqlJob
4. Copy-SqlDatabaseMail
5. Copy-SqlLinkedServer

In some of the following posts I will share how some of these are used.