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 & 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
Microsoft, 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
Technical Evangelist, Microsoft

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

dbatools and docker

We now provide Docker images to help dbatools users easily create a non-production environment to test commands and safely explore our toolset.

announcements

multithreading commands

In this age of many companies adopting the ideas of either DevOps or SRE (Site Reliability Engineer) roles, there is constant need for automation. Mundane tasks like collecting metrics, alerts, …

announcements

powershell splatting

Splatting in PowerShell makes code easier to read. Instead of typing a bunch of parameters allllll across the screen, you can use an easy-to-read hashtable or array. Argument splatting was …

read the dbatools blog