dbatools

0.8.6

Provides extra functionality for SQL Server Database admins and enables SQL Server instance migrations.

Minimum PowerShell version

3.0

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name dbatools -RequiredVersion 0.8.6

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Author(s)

Chrissy LeMaire

Copyright

2016 Chrissy LeMaire

Owners

Tags

sqlserver migrations sql dba databases

Functions

Start-SqlMigration Copy-SqlDatabase Copy-SqlLogin Copy-SqlServerAgent Copy-SqlSpConfigure Copy-SqlLinkedServer Copy-SqlDatabaseMail Copy-SqlDatabaseAssembly Copy-SqlPolicyManagement Copy-SqlSharedSchedule Copy-SqlOperator Copy-SqlJob Copy-SqlDataCollector Copy-SqlCustomError Copy-SqlAuditSpecification Copy-SqlEndpoint Copy-SqlAudit Copy-SqlServerRole Copy-SqlResourceGovernor Copy-SqlExtendedEvent Copy-SqlBackupDevice Copy-SqlServerTrigger Copy-SqlCredential Copy-SqlCentralManagementServer Copy-SqlSysDbUserObjects Copy-SqlProxyAccount Copy-SqlAlert Import-SqlSpConfigure Export-SqlSpConfigure Get-SqlMaxMemory Get-DbaDetachedDatabaseInfo Restore-SqlBackupFromDirectory Test-SqlConnection Import-CsvToSql Copy-SqlAgentCategory Update-dbatools Test-SqlPath Sync-SqlLoginPermissions Export-SqlLogin Get-SqlServerKey Set-SqlMaxMemory Reset-SqlAdmin Watch-SqlDbLogin Expand-SqlTLogResponsibly Test-SqlMigrationConstraint Get-SqlRegisteredServerName Test-SqlNetworkLatency Find-SqlDuplicateIndex Show-SqlServerFileSystem Get-DbaDiskSpace Remove-SqlDatabaseSafely Show-SqlDatabaseList Show-SqlWhoIsActive Set-SqlTempDbConfiguration Test-SqlTempDbConfiguration Repair-SqlOrphanUser Remove-SqlOrphanUser Find-SqlUnusedIndex Install-SqlWhoIsActive Update-SqlWhoIsActive Test-DbaDiskAllocation Test-DbaPowerPlan Set-DbaPowerPlan Test-DbaDiskAlignment Get-DbaDatabaseFreespace Get-DbaClusterActiveNode Test-DbaDatabaseOwner Set-DbaDatabaseOwner Test-DbaJobOwner Set-DbaJobOwner Test-DbaVirtualLogFile Get-DbaRestoreHistory Get-DbaTcpPort Test-DbaDatabaseCompatibility Test-DbaDatabaseCollation Test-DbaConnectionAuthScheme Test-DbaServerName Repair-DbaServerName Stop-DbaProcess Get-DbaProcess Get-DbaAvailabilityGroup Test-DbaMaxDop Copy-SqlSsisCatalog Get-DbaLastGoodCheckDb Test-DbaDatabaseBestPractice Remove-DbaBackup Find-DbaOrphanedFile Test-DbaFullRecoveryModel Get-DbaRunningJob Set-DbaMaxDop

Dependencies

This module has no dependencies.

Version History

Version Downloads Last updated
0.9.757 1,135 2/12/2019
0.9.755 766 2/9/2019
0.9.754 1,024 2/7/2019
0.9.753 423 2/6/2019
0.9.752 1,260 2/3/2019
0.9.751 732 1/31/2019
0.9.750 1,677 1/25/2019
0.9.749 233 1/24/2019
0.9.748 234 1/24/2019
0.9.747 238 1/23/2019
0.9.745 133 1/23/2019
0.9.744 84 1/23/2019
0.9.743 844 1/20/2019
0.9.742 1,520 1/15/2019
0.9.741 679 1/11/2019
0.9.740 91 1/11/2019
0.9.739 136 1/11/2019
0.9.738 210 1/10/2019
0.9.737 642 1/8/2019
0.9.735 394 1/7/2019
0.9.734 1,452 1/2/2019
0.9.733 420 12/31/2018
0.9.732 669 12/26/2018
0.9.731 340 12/23/2018
0.9.730 474 12/21/2018
0.9.729 17 12/21/2018
0.9.728 10 12/21/2018
0.9.725 249 12/20/2018
0.9.724 164 12/20/2018
0.9.722 398 12/19/2018
0.9.721 515 12/18/2018
0.9.720 548 12/16/2018
0.9.719 80 12/15/2018
0.9.718 182 12/14/2018
0.9.717 125 12/14/2018
0.9.715 344 12/12/2018
0.9.714 785 12/10/2018
0.9.712 289 12/9/2018
0.9.711 480 12/7/2018
0.9.710 536 12/5/2018
0.9.709 657 12/4/2018
0.9.708 25 12/4/2018
0.9.707 20 12/3/2018
0.9.705 63 12/3/2018
0.9.704 326 12/3/2018
0.9.703 55 12/2/2018
0.9.702 51 12/2/2018
0.9.701 265 12/1/2018
0.9.700 4 12/1/2018
0.9.538 186 11/30/2018
0.9.537 127 11/30/2018
0.9.535 168 11/29/2018
0.9.534 168 11/29/2018
0.9.533 667 11/27/2018
0.9.532 373 11/26/2018
0.9.531 418 11/24/2018
0.9.530 23 11/24/2018
0.9.528 19 11/24/2018
0.9.527 105 11/23/2018
0.9.525 22 11/23/2018
0.9.524 10 11/23/2018
0.9.523 72 11/23/2018
0.9.522 69 11/23/2018
0.9.521 219 11/22/2018
0.9.520 162 11/22/2018
0.9.519 1,446 11/17/2018
0.9.518 233 11/16/2018
0.9.517 262 11/15/2018
0.9.515 59 11/15/2018
0.9.512 664 11/14/2018
0.9.511 28 11/14/2018
0.9.510 86 11/14/2018
0.9.509 649 11/12/2018
0.9.508 240 11/12/2018
0.9.507 305 11/9/2018
0.9.505 5 11/9/2018
0.9.504 599 11/8/2018
0.9.503 189 11/7/2018
0.9.502 147 11/7/2018
0.9.501 897 11/5/2018
0.9.500 246 11/3/2018
0.9.499 317 11/2/2018
0.9.498 105 11/2/2018
0.9.497 704 10/31/2018
0.9.495 299 10/30/2018
0.9.494 207 10/29/2018
0.9.493 144 10/29/2018
0.9.492 264 10/28/2018
0.9.491 459 10/26/2018
0.9.490 749 10/24/2018
0.9.489 136 10/23/2018
0.9.488 6 10/23/2018
0.9.487 1,133 10/18/2018
0.9.485 289 10/18/2018
0.9.484 866 10/16/2018
0.9.483 185 10/15/2018
0.9.482 37 10/15/2018
0.9.481 86 10/15/2018
0.9.480 45 10/15/2018
0.9.479 110 10/14/2018
0.9.478 5 10/14/2018
0.9.477 381 10/12/2018
0.9.475 229 10/11/2018
0.9.474 195 10/11/2018
0.9.473 527 10/10/2018
0.9.472 201 10/9/2018
0.9.471 576 10/8/2018
0.9.470 130 10/7/2018
0.9.459 42 10/7/2018
0.9.458 51 10/6/2018
0.9.457 25 10/6/2018
0.9.455 352 10/4/2018
0.9.454 243 10/4/2018
0.9.453 345 10/3/2018
0.9.452 12 10/3/2018
0.9.451 23 10/3/2018
0.9.450 648 10/1/2018
0.9.447 329 9/29/2018
0.9.445 661 9/26/2018
0.9.443 44 9/26/2018
0.9.442 86 9/26/2018
0.9.441 7 9/26/2018
0.9.440 85 9/26/2018
0.9.439 129 9/26/2018
0.9.438 14 9/25/2018
0.9.437 11 9/25/2018
0.9.435 731 9/24/2018
0.9.434 119 9/23/2018
0.9.433 307 9/21/2018
0.9.432 246 9/20/2018
0.9.431 373 9/19/2018
0.9.430 12 9/19/2018
0.9.429 13 9/19/2018
0.9.428 160 9/19/2018
0.9.427 272 9/18/2018
0.9.425 20 9/18/2018
0.9.424 73 9/18/2018
0.9.423 10 9/18/2018
0.9.422 341 9/16/2018
0.9.421 5 9/16/2018
0.9.420 13 9/16/2018
0.9.419 342 9/14/2018
0.9.418 926 9/11/2018
0.9.417 554 9/9/2018
0.9.415 127 9/8/2018
0.9.412 51 9/7/2018
0.9.411 268 9/7/2018
0.9.410 109 9/7/2018
0.9.405 3 9/7/2018
0.9.402 308 9/6/2018
0.9.400 369 9/5/2018
0.9.399 632 8/31/2018
0.9.398 212 8/30/2018
0.9.395 558 8/28/2018
0.9.394 402 8/26/2018
0.9.393 457 8/23/2018
0.9.392 467 8/22/2018
0.9.391 462 8/21/2018
0.9.390 196 8/20/2018
0.9.389 298 8/18/2018
0.9.388 180 8/17/2018
0.9.387 465 8/15/2018
0.9.385 1,628 8/8/2018
0.9.384 1,102 8/2/2018
0.9.383 210 8/1/2018
0.9.382 1,483 7/26/2018
0.9.381 166 7/26/2018
0.9.380 616 7/23/2018
0.9.378 204 7/22/2018
0.9.377 162 7/20/2018
0.9.376 711 7/18/2018
0.9.375 728 7/15/2018
0.9.374 74 7/14/2018
0.9.373 295 7/12/2018
0.9.372 3 7/12/2018
0.9.371 171 7/12/2018
0.9.370 957 7/6/2018
0.9.369 376 7/5/2018
0.9.368 80 7/5/2018
0.9.367 52 7/4/2018
0.9.365 153 7/3/2018
0.9.364 132 7/3/2018
0.9.363 379 7/1/2018
0.9.362 563 6/28/2018
0.9.361 8 6/28/2018
0.9.360 220 6/27/2018
0.9.359 534 6/25/2018
0.9.358 100 6/25/2018
0.9.357 636 6/21/2018
0.9.355 13 6/21/2018
0.9.354 449 6/19/2018
0.9.353 10 6/19/2018
0.9.352 92 6/19/2018
0.9.351 66 6/19/2018
0.9.350 12 6/19/2018
0.9.349 675 6/15/2018
0.9.348 760 6/12/2018
0.9.347 827 6/10/2018
0.9.346 3 6/10/2018
0.9.345 274 6/8/2018
0.9.344 8 6/8/2018
0.9.343 338 6/7/2018
0.9.342 1,269 6/1/2018
0.9.341 307 5/31/2018
0.9.340 75 5/31/2018
0.9.339 282 5/30/2018
0.9.338 818 5/25/2018
0.9.337 42 5/25/2018
0.9.336 184 5/24/2018
0.9.335 1,338 5/17/2018
0.9.334 650 5/15/2018
0.9.333 806 5/9/2018
0.9.332 611 5/7/2018
0.9.331 145 5/4/2018
0.9.330 666 5/1/2018
0.9.329 346 4/28/2018
0.9.327 289 4/26/2018
0.9.326 450 4/24/2018
0.9.325 2,126 4/12/2018
0.9.324 369 4/10/2018
0.9.323 124 4/10/2018
0.9.322 229 4/9/2018
0.9.321 681 4/4/2018
0.9.320 5 4/4/2018
0.9.319 104 4/4/2018
0.9.318 602 4/1/2018
0.9.317 212 3/30/2018
0.9.316 499 3/28/2018
0.9.315 287 3/27/2018
0.9.314 33 3/27/2018
0.9.312 12 3/27/2018
0.9.311 198 3/26/2018
0.9.310 221 3/24/2018
0.9.308 3 3/24/2018
0.9.307 312 3/22/2018
0.9.306 303 3/21/2018
0.9.305 568 3/18/2018
0.9.304 95 3/16/2018
0.9.303 10 3/16/2018
0.9.302 404 3/14/2018
0.9.301 2,100 3/5/2018
0.9.300 962 2/28/2018
0.9.211 292 2/27/2018
0.9.210 589 2/24/2018
0.9.209 483 2/22/2018
0.9.208 245 2/22/2018
0.9.207 236 2/20/2018
0.9.205 10 2/20/2018
0.9.204 190 2/19/2018
0.9.203 72 2/18/2018
0.9.202 16 2/18/2018
0.9.201 62 2/17/2018
0.9.200 52 2/16/2018
0.9.199 85 2/16/2018
0.9.198 293 2/14/2018
0.9.197 124 2/13/2018
0.9.196 11 2/13/2018
0.9.195 254 2/12/2018
0.9.194 95 2/11/2018
0.9.193 180 2/9/2018
0.9.192 614 2/6/2018
0.9.191 146 2/5/2018
0.9.190 382 2/1/2018
0.9.189 196 1/31/2018
0.9.188 673 1/26/2018
0.9.187 89 1/25/2018
0.9.186 9 1/25/2018
0.9.185 175 1/24/2018
0.9.184 7 1/24/2018
0.9.183 307 1/23/2018
0.9.182 168 1/22/2018
0.9.181 76 1/22/2018
0.9.180 33 1/21/2018
0.9.179 23 1/20/2018
0.9.177 86 1/19/2018
0.9.176 80 1/19/2018
0.9.175 180 1/17/2018
0.9.174 138 1/16/2018
0.9.173 129 1/16/2018
0.9.172 6 1/16/2018
0.9.171 44 1/15/2018
0.9.170 109 1/15/2018
0.9.162 36 1/13/2018
0.9.161 4 1/13/2018
0.9.160 28 1/13/2018
0.9.159 6 1/13/2018
0.9.158 39 1/12/2018
0.9.157 18 1/12/2018
0.9.156 263 1/10/2018
0.9.155 14 1/10/2018
0.9.153 222 1/9/2018
0.9.152 82 1/9/2018
0.9.151 119 1/8/2018
0.9.150 352 1/5/2018
0.9.148 132 1/4/2018
0.9.147 7 1/4/2018
0.9.145 310 1/2/2018
0.9.144 51 12/31/2017
0.9.143 24 12/30/2017
0.9.142 74 12/29/2017
0.9.141 38 12/28/2017
0.9.140 224 12/25/2017
0.9.139 15 12/24/2017
0.9.138 17 12/23/2017
0.9.137 144 12/21/2017
0.9.136 250 12/20/2017
0.9.135 183 12/19/2017
0.9.134 19 12/19/2017
0.9.133 168 12/18/2017
0.9.132 82 12/16/2017
0.9.130 28 12/15/2017
0.9.129 14 12/15/2017
0.9.128 149 12/15/2017
0.9.127 45 12/15/2017
0.9.126 258 12/14/2017
0.9.125 64 12/14/2017
0.9.124 286 12/13/2017
0.9.123 36 12/13/2017
0.9.122 188 12/12/2017
0.9.121 14 12/12/2017
0.9.120 147 12/11/2017
0.9.119 288 12/7/2017
0.9.118 138 12/6/2017
0.9.117 77 12/6/2017
0.9.116 28 12/6/2017
0.9.114 111 12/5/2017
0.9.112 94 12/5/2017
0.9.111 124 12/4/2017
0.9.110 333 12/1/2017
0.9.109 20 11/30/2017
0.9.108 128 11/29/2017
0.9.107 161 11/28/2017
0.9.106 200 11/26/2017
0.9.105 792 11/17/2017
0.9.104 32 11/17/2017
0.9.103 9 11/17/2017
0.9.102 30 11/17/2017
0.9.101 221 11/16/2017
0.9.100 136 11/15/2017
0.9.99 80 11/15/2017
0.9.98 67 11/15/2017
0.9.97 149 11/14/2017
0.9.96 52 11/14/2017
0.9.95 327 11/11/2017
0.9.94 11 11/11/2017
0.9.93 289 11/9/2017
0.9.92 20 11/9/2017
0.9.91 5 11/9/2017
0.9.90 19 11/9/2017
0.9.89 81 11/8/2017
0.9.88 175 11/7/2017
0.9.87 144 11/6/2017
0.9.86 162 11/6/2017
0.9.85 425 11/2/2017
0.9.84 568 10/30/2017
0.9.83 247 10/27/2017
0.9.82 69 10/27/2017
0.9.81 23 10/27/2017
0.9.80 41 10/26/2017
0.9.79 61 10/26/2017
0.9.78 19 10/26/2017
0.9.77 240 10/24/2017
0.9.76 44 10/24/2017
0.9.75 15 10/24/2017
0.9.74 6 10/24/2017
0.9.73 510 10/19/2017
0.9.72 372 10/18/2017
0.9.71 84 10/17/2017
0.9.70 437 10/12/2017
0.9.69 193 10/11/2017
0.9.68 338 10/10/2017
0.9.67 126 10/9/2017
0.9.65 181 10/6/2017
0.9.64 174 10/5/2017
0.9.63 315 10/4/2017
0.9.62 702 9/30/2017
0.9.61 22 9/30/2017
0.9.60 176 9/28/2017
0.9.59 181 9/28/2017
0.9.58 68 9/27/2017
0.9.57 488 9/26/2017
0.9.56 438 9/25/2017
0.9.55 9 9/25/2017
0.9.54 37 9/25/2017
0.9.53 84 9/22/2017
0.9.52 47 9/22/2017
0.9.51 53 9/22/2017
0.9.50 9 9/22/2017
0.9.49 102 9/20/2017
0.9.48 123 9/19/2017
0.9.47 14 9/19/2017
0.9.46 39 9/19/2017
0.9.45 115 9/18/2017
0.9.44 164 9/14/2017
0.9.43 5 9/14/2017
0.9.42 418 9/13/2017
0.9.41 526 9/7/2017
0.9.40 170 9/6/2017
0.9.39 525 8/27/2017
0.9.38 12 8/26/2017
0.9.37 6 8/26/2017
0.9.34 429 8/18/2017
0.9.33 10 8/18/2017
0.9.32 5 8/18/2017
0.9.31 87 8/17/2017
0.9.30 6 8/17/2017
0.9.29 212 8/14/2017
0.9.28 86 8/14/2017
0.9.27 68 8/11/2017
0.9.26 17 8/11/2017
0.9.25 210 8/9/2017
0.9.24 240 8/4/2017
0.9.23 46 8/4/2017
0.9.22 368 7/30/2017
0.9.21 14 7/29/2017
0.9.20 154 7/27/2017
0.9.19 121 7/26/2017
0.9.18 212 7/23/2017
0.9.17 13 7/23/2017
0.9.16 9 7/23/2017
0.9.15 20 7/22/2017
0.9.12 15 7/22/2017
0.9.11 12 7/21/2017
0.9.10 71 7/21/2017
0.9.9 47 7/20/2017
0.9.7 31 7/20/2017
0.9.6 11 7/20/2017
0.9.4 48 7/20/2017
0.9.3 137 7/19/2017
0.8.957 2,283 5/16/2017
0.8.956 204 5/11/2017
0.8.955 153 5/9/2017
0.8.954 76 5/9/2017
0.8.953 7 5/9/2017
0.8.952 43 5/8/2017
0.8.951 68 5/8/2017
0.8.950 133 5/4/2017
0.8.948 474 4/25/2017
0.8.947 196 4/19/2017
0.8.946 8 4/19/2017
0.8.945 351 4/11/2017
0.8.944 480 3/29/2017
0.8.943 219 3/22/2017
0.8.942 304 3/15/2017
0.8.941 12 3/15/2017
0.8.940 114 3/10/2017
0.8.939 34 3/10/2017
0.8.938 224 3/5/2017
0.8.937 96 3/4/2017
0.8.935 24 3/4/2017
0.8.934 9 3/4/2017
0.8.933 160 3/1/2017
0.8.932 8 3/1/2017
0.8.931 93 2/28/2017
0.8.930 64 2/27/2017
0.8.929 48 2/27/2017
0.8.928 52 2/24/2017
0.8.925 20 2/24/2017
0.8.920 24 2/24/2017
0.8.915 13 2/24/2017
0.8.914 32 2/24/2017
0.8.912 7 2/24/2017
0.8.910 12 2/23/2017
0.8.908 13 2/23/2017
0.8.905 33 2/23/2017
0.8.904 34 2/22/2017
0.8.903 218 2/20/2017
0.8.902 74 2/18/2017
0.8.901 151 2/15/2017
0.8.900 143 2/13/2017
0.8.709 153 2/8/2017
0.8.708 17 2/8/2017
0.8.707 47 2/7/2017
0.8.705 57 2/7/2017
0.8.704 6 2/7/2017
0.8.702 19 2/6/2017
0.8.701 21 2/6/2017
0.8.700 32 2/5/2017
0.8.695 17 2/4/2017
0.8.694 121 2/1/2017
0.8.692 909 12/16/2016
0.8.691 69 12/14/2016
0.8.69 30 12/13/2016
0.8.68 231 11/30/2016
0.8.66 67 11/27/2016
0.8.65 96 11/22/2016
0.8.61 263 11/2/2016
0.8.6 (current version) 90 10/29/2016
0.8.5.56 363 9/26/2016
0.8.5.55 21 9/26/2016
0.8.5.53 292 8/20/2016
0.8.5.52 48 8/18/2016
0.8.5.51 8 8/18/2016
0.8.5.50 26 8/17/2016
0.8.5.5 8 8/17/2016
0.8.5.3 17 8/16/2016
0.8.5.2 16 8/16/2016
0.8.4.8 126 7/29/2016
0.8.4.7 10 7/28/2016
0.8.4.6 28 7/25/2016
0.8.4.4 32 7/23/2016
0.8.4.1 43 7/20/2016
0.8.4.0 13 7/20/2016
0.8.3.5 16 7/18/2016
0.8.3.4 19 7/18/2016
0.8.3.3 8 7/17/2016
0.8.3.2 11 7/17/2016
0.8.3.1 8 7/17/2016
0.8.3.0 8 7/17/2016
0.8.2.9 8 7/17/2016
0.8.2.8 8 7/17/2016
0.8.2.7 14 7/16/2016
0.8.2.6 8 7/16/2016
0.8.2.5 14 7/15/2016
0.8.2.4 8 7/15/2016
0.8.1.9 50 7/5/2016
0.8.1.8 33 6/28/2016
0.8.1.7 30 6/23/2016
0.8.1.5 36 6/18/2016
0.8.1.3 22 6/14/2016
0.8.1.2 15 6/14/2016
0.8.1.1 8 6/14/2016
0.8.1.0 29 6/4/2016
0.8.0.8 40 5/21/2016
0.8.0.7 8 5/21/2016
0.8.0.6 18 5/17/2016
0.8.0.5 10 5/16/2016
0.8.0.4 7 5/16/2016
0.8.0.2 8 5/16/2016
0.8.0.1 9 5/16/2016
0.8.0.0 10 5/16/2016
0.7.9.9 8 5/15/2016
0.7.9.8 12 5/15/2016
0.7.9.7 11 5/15/2016
Show less