PowerShell

SQL Server

Instance migrations and best practice implementations have never been safer, faster or freer.

Download Get Started

features

free & open source

no cost to you or your company

community driven

created by the SQL Server community

automation is awesome

less room for human error

lots of upvotes

(394)

Watch a SQL Server to
SQL Server migration

community ❤️ dbatools

Michael J Swart
Data Platform MVP

This dev just used dbatools to install and migrate 50 db machines at once with little effort or errors. It's truly the easy button.

Steve Jones
MVP & Editor at SQLServerCentral.com

If you haven’t played with dbatools, I’d recommend you do so; it makes working with SQL and PowerShell much easier.

Argenis Fernandez
MVP, MCM, vExpert

I can't stress enough how good dbatools is. Stop doing it the hard way.

Andy Nakamura
SQL Saturday Speaker

I had been seriously thinking of quitting the SQL space altogether and decided to get into other things, but this has got to be a great addition to becoming a better DBA.

Joey D'antoni
MVP, vExpert, DCAC

dbatools is an amazing project. Tasks like server migrations that used to take me hours can now be completed in seconds, and with total confidence.

Nikhil Chintalapudi
SQL Server DBA

Thank you for this module. It's very helpful for a someone like me trying to automate database tasks without very much PowerShell experience.

Jeffery Hicks
MVP, Author

If you are a SQL person you need to check out the dbatools PowerShell project.

Mike Martin
Microsoft Azure MVP

If there was a thing such as MVP for MVP'S then dbatools would probably win it.

André Kamman
MVP & Dutch PASS Chapter Leader

dbatools are the most important PowerShell scripts for SQL Server DBAs.

latest updates

announcements

default parameter values

When connecting to a SQL Server instance with alternative credentials, it can be tedious to repeat the SQL credential over and over. The great news is that this repetition is …

announcements

managing central management server

SQL Server’s Central Management Server (CMS), first introduced in SQL Server 2008, “stores a list of instances of SQL Server that is organized into one or more central management server …

announcements

simplifying snapshots

I remember the first time I saw database snapshots, I was so excited. Then I right-clicked in SSMS and.. No way to easily create a snapshot. So then I researched …

read the dbatools blog