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

breaking changes update

Before I go into the breaking changes introduced in 0.9.518, I wanted to highlight Invoke-DbatoolsRenameHelper which is an awesome command that will help you with a vast majority of our …

announcements

dbatools 1.0 progress!

Thanks to several of our team members, we’re now progressing quickly towards dbatools 1.0! 🤗 The progress is so encouraging, I believe 1.0 is around the corner. Because of this, …

announcements

hacktoberfest – dbatools edition

During the month of October 2018 DigitalOcean is again running Hacktoberfest to support open source projects. They are offering a limited edition T-Shirt for any person making five pull requests …

announcements

more updates

Just a quick note that we’ve made more changes to align with 1.0, now available in version 0.9.453. Renamed Log Shipping Get-DbaDbLogShipError Invoke-DbaDbLogShipping Invoke-DbaDbLogShipRecovery Test-DbaDbLogShipStatus Registered Servers (Central Management Server) …

read the dbatools blog