github dataplat/dbatools v2.0.0
on GitHub

latest releases: v2.1.27, v2.1.26, v2.1.25...
18 months ago

After 5 months of hard work, dbatools 2.0 is finally here!

THIS RELEASE INCLUDES BREAKING CHANGES.

Most notably, we updated the SQL Server libraries, which brings more power, bug fixes and breaking changes of its own. The one that will cause the most headaches is the change to encryption. Now, Trust Certificate is set to false and Encrypt is set to true. We wrote a few posts about this:

Our library files (the DLLs) are also now included in their own module, dbatools.library. This means that dbatools will ultimately be smaller in size and take up less disk space for those who update often. It also means that the way you install dbatools in offline environments has changed.

Highlighted changes

A couple months ago, I wrote a post that detailed more of our changes, which you can find here:

Here are some other highlights people may appreciate

  • Support for SQL Server 2022
  • The import process should now be much faster, as it now uses compression which requires less reading from disk
  • SSIS commands have been added back for the Windows platform
  • functions/internal is now public/private (for devs)
  • devcontainer now works better (for devs)
  • geometry/geography/hierarchyid types now work for people who need them
  • Autocomplete has been fixed, so after connecting at least once, hit tab to auto complete SqlInstance, Database, Job and more
  • Install-DbaMultiTool now installs sp_help_revlogin
  • Network certificate-related commands work better
  • Sync-DbaAvailabilityGroup now shows details when -WhatIf is used
  • Whatif output has been standardized in all Copy (and Start-DbaMigration) commands
  • Test-DbaLastBackup now works even better for more scenarios like copying backups with multiple files
  • Ola Hallengren's Maintenance Solution is now included which helps those with offline networks

Don't have time to mess with a new release today, consider it's a Friday? You can install the latest 1.x release by running the following command: 

Install-Module dbatools -RequiredVersion 1.1.146

Azure DevOps and Automation changes

When I created an Azure Automation test, I had to install dbatools.library first. You may have to do that for Azure DevOps as well, so be sure to update your pipelines 🚀

Everything that's changed

I'll likely update this README a few times as I discover a few things that I'd like to highlight. I also plan to fix dbatools.io so that I can publish blog posts there again, so keep an eye out for a new fresh Hugo site.

Until then, here is an exhaustive list of the changes that have been made since October.

New Contributors

Full Changelog: v1.1.142...v2.0.0

Check out latest releases or
releases around dataplat/dbatools v2.0.0

Don't miss a new dbatools release

NewReleases is sending notifications on new releases.

Get notifications