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.519 7 11/17/2018
0.9.518 227 11/16/2018
0.9.517 260 11/15/2018
0.9.515 58 11/15/2018
0.9.512 662 11/14/2018
0.9.511 27 11/14/2018
0.9.510 84 11/14/2018
0.9.509 635 11/12/2018
0.9.508 238 11/12/2018
0.9.507 294 11/9/2018
0.9.505 4 11/9/2018
0.9.504 596 11/8/2018
0.9.503 188 11/7/2018
0.9.502 145 11/7/2018
0.9.501 890 11/5/2018
0.9.500 242 11/3/2018
0.9.499 316 11/2/2018
0.9.498 104 11/2/2018
0.9.497 703 10/31/2018
0.9.495 298 10/30/2018
0.9.494 206 10/29/2018
0.9.493 143 10/29/2018
0.9.492 263 10/28/2018
0.9.491 457 10/26/2018
0.9.490 746 10/24/2018
0.9.489 135 10/23/2018
0.9.488 5 10/23/2018
0.9.487 1,131 10/18/2018
0.9.485 288 10/18/2018
0.9.484 865 10/16/2018
0.9.483 177 10/15/2018
0.9.482 36 10/15/2018
0.9.481 85 10/15/2018
0.9.480 44 10/15/2018
0.9.479 109 10/14/2018
0.9.478 4 10/14/2018
0.9.477 380 10/12/2018
0.9.475 228 10/11/2018
0.9.474 194 10/11/2018
0.9.473 526 10/10/2018
0.9.472 196 10/9/2018
0.9.471 575 10/8/2018
0.9.470 129 10/7/2018
0.9.459 41 10/7/2018
0.9.458 50 10/6/2018
0.9.457 3 10/6/2018
0.9.455 351 10/4/2018
0.9.454 242 10/4/2018
0.9.453 344 10/3/2018
0.9.452 11 10/3/2018
0.9.451 22 10/3/2018
0.9.450 602 10/1/2018
0.9.447 326 9/29/2018
0.9.445 658 9/26/2018
0.9.443 43 9/26/2018
0.9.442 85 9/26/2018
0.9.441 6 9/26/2018
0.9.440 84 9/26/2018
0.9.439 128 9/26/2018
0.9.438 13 9/25/2018
0.9.437 10 9/25/2018
0.9.435 729 9/24/2018
0.9.434 118 9/23/2018
0.9.433 306 9/21/2018
0.9.432 245 9/20/2018
0.9.431 364 9/19/2018
0.9.430 11 9/19/2018
0.9.429 12 9/19/2018
0.9.428 159 9/19/2018
0.9.427 266 9/18/2018
0.9.425 19 9/18/2018
0.9.424 72 9/18/2018
0.9.423 9 9/18/2018
0.9.422 339 9/16/2018
0.9.421 4 9/16/2018
0.9.420 12 9/16/2018
0.9.419 341 9/14/2018
0.9.418 924 9/11/2018
0.9.417 552 9/9/2018
0.9.415 126 9/8/2018
0.9.412 50 9/7/2018
0.9.411 266 9/7/2018
0.9.410 98 9/7/2018
0.9.405 2 9/7/2018
0.9.402 307 9/6/2018
0.9.400 367 9/5/2018
0.9.399 630 8/31/2018
0.9.398 210 8/30/2018
0.9.395 557 8/28/2018
0.9.394 401 8/26/2018
0.9.393 456 8/23/2018
0.9.392 466 8/22/2018
0.9.391 461 8/21/2018
0.9.390 194 8/20/2018
0.9.389 297 8/18/2018
0.9.388 179 8/17/2018
0.9.387 464 8/15/2018
0.9.385 1,626 8/8/2018
0.9.384 1,101 8/2/2018
0.9.383 209 8/1/2018
0.9.382 1,461 7/26/2018
0.9.381 165 7/26/2018
0.9.380 615 7/23/2018
0.9.378 203 7/22/2018
0.9.377 161 7/20/2018
0.9.376 710 7/18/2018
0.9.375 709 7/15/2018
0.9.374 73 7/14/2018
0.9.373 293 7/12/2018
0.9.372 2 7/12/2018
0.9.371 170 7/12/2018
0.9.370 955 7/6/2018
0.9.369 375 7/5/2018
0.9.368 79 7/5/2018
0.9.367 51 7/4/2018
0.9.365 152 7/3/2018
0.9.364 131 7/3/2018
0.9.363 378 7/1/2018
0.9.362 562 6/28/2018
0.9.361 7 6/28/2018
0.9.360 219 6/27/2018
0.9.359 533 6/25/2018
0.9.358 81 6/25/2018
0.9.357 634 6/21/2018
0.9.355 12 6/21/2018
0.9.354 448 6/19/2018
0.9.353 9 6/19/2018
0.9.352 91 6/19/2018
0.9.351 65 6/19/2018
0.9.350 11 6/19/2018
0.9.349 674 6/15/2018
0.9.348 759 6/12/2018
0.9.347 826 6/10/2018
0.9.346 2 6/10/2018
0.9.345 273 6/8/2018
0.9.344 7 6/8/2018
0.9.343 337 6/7/2018
0.9.342 1,267 6/1/2018
0.9.341 306 5/31/2018
0.9.340 74 5/31/2018
0.9.339 281 5/30/2018
0.9.338 813 5/25/2018
0.9.337 41 5/25/2018
0.9.336 183 5/24/2018
0.9.335 1,336 5/17/2018
0.9.334 648 5/15/2018
0.9.333 805 5/9/2018
0.9.332 610 5/7/2018
0.9.331 143 5/4/2018
0.9.330 665 5/1/2018
0.9.329 345 4/28/2018
0.9.327 288 4/26/2018
0.9.326 449 4/24/2018
0.9.325 2,125 4/12/2018
0.9.324 368 4/10/2018
0.9.323 123 4/10/2018
0.9.322 228 4/9/2018
0.9.321 680 4/4/2018
0.9.320 4 4/4/2018
0.9.319 102 4/4/2018
0.9.318 601 4/1/2018
0.9.317 211 3/30/2018
0.9.316 498 3/28/2018
0.9.315 286 3/27/2018
0.9.314 32 3/27/2018
0.9.312 11 3/27/2018
0.9.311 197 3/26/2018
0.9.310 220 3/24/2018
0.9.308 2 3/24/2018
0.9.307 309 3/22/2018
0.9.306 302 3/21/2018
0.9.305 567 3/18/2018
0.9.304 94 3/16/2018
0.9.303 9 3/16/2018
0.9.302 403 3/14/2018
0.9.301 2,099 3/5/2018
0.9.300 961 2/28/2018
0.9.211 291 2/27/2018
0.9.210 588 2/24/2018
0.9.209 482 2/22/2018
0.9.208 244 2/22/2018
0.9.207 235 2/20/2018
0.9.205 9 2/20/2018
0.9.204 189 2/19/2018
0.9.203 71 2/18/2018
0.9.202 15 2/18/2018
0.9.201 61 2/17/2018
0.9.200 51 2/16/2018
0.9.199 84 2/16/2018
0.9.198 292 2/14/2018
0.9.197 123 2/13/2018
0.9.196 9 2/13/2018
0.9.195 253 2/12/2018
0.9.194 94 2/11/2018
0.9.193 179 2/9/2018
0.9.192 612 2/6/2018
0.9.191 145 2/5/2018
0.9.190 381 2/1/2018
0.9.189 195 1/31/2018
0.9.188 672 1/26/2018
0.9.187 88 1/25/2018
0.9.186 8 1/25/2018
0.9.185 174 1/24/2018
0.9.184 6 1/24/2018
0.9.183 306 1/23/2018
0.9.182 167 1/22/2018
0.9.181 75 1/22/2018
0.9.180 32 1/21/2018
0.9.179 22 1/20/2018
0.9.177 85 1/19/2018
0.9.176 79 1/19/2018
0.9.175 179 1/17/2018
0.9.174 137 1/16/2018
0.9.173 128 1/16/2018
0.9.172 5 1/16/2018
0.9.171 43 1/15/2018
0.9.170 108 1/15/2018
0.9.162 35 1/13/2018
0.9.161 3 1/13/2018
0.9.160 26 1/13/2018
0.9.159 5 1/13/2018
0.9.158 38 1/12/2018
0.9.157 17 1/12/2018
0.9.156 262 1/10/2018
0.9.155 13 1/10/2018
0.9.153 221 1/9/2018
0.9.152 81 1/9/2018
0.9.151 118 1/8/2018
0.9.150 351 1/5/2018
0.9.148 131 1/4/2018
0.9.147 6 1/4/2018
0.9.145 309 1/2/2018
0.9.144 50 12/31/2017
0.9.143 23 12/30/2017
0.9.142 73 12/29/2017
0.9.141 37 12/28/2017
0.9.140 223 12/25/2017
0.9.139 14 12/24/2017
0.9.138 16 12/23/2017
0.9.137 143 12/21/2017
0.9.136 249 12/20/2017
0.9.135 182 12/19/2017
0.9.134 18 12/19/2017
0.9.133 167 12/18/2017
0.9.132 80 12/16/2017
0.9.130 27 12/15/2017
0.9.129 13 12/15/2017
0.9.128 148 12/15/2017
0.9.127 44 12/15/2017
0.9.126 257 12/14/2017
0.9.125 63 12/14/2017
0.9.124 285 12/13/2017
0.9.123 35 12/13/2017
0.9.122 187 12/12/2017
0.9.121 13 12/12/2017
0.9.120 146 12/11/2017
0.9.119 287 12/7/2017
0.9.118 137 12/6/2017
0.9.117 76 12/6/2017
0.9.116 27 12/6/2017
0.9.114 110 12/5/2017
0.9.112 93 12/5/2017
0.9.111 123 12/4/2017
0.9.110 332 12/1/2017
0.9.109 19 11/30/2017
0.9.108 127 11/29/2017
0.9.107 160 11/28/2017
0.9.106 199 11/26/2017
0.9.105 791 11/17/2017
0.9.104 31 11/17/2017
0.9.103 8 11/17/2017
0.9.102 29 11/17/2017
0.9.101 220 11/16/2017
0.9.100 135 11/15/2017
0.9.99 79 11/15/2017
0.9.98 66 11/15/2017
0.9.97 148 11/14/2017
0.9.96 51 11/14/2017
0.9.95 326 11/11/2017
0.9.94 10 11/11/2017
0.9.93 288 11/9/2017
0.9.92 19 11/9/2017
0.9.91 4 11/9/2017
0.9.90 18 11/9/2017
0.9.89 80 11/8/2017
0.9.88 174 11/7/2017
0.9.87 143 11/6/2017
0.9.86 161 11/6/2017
0.9.85 424 11/2/2017
0.9.84 566 10/30/2017
0.9.83 246 10/27/2017
0.9.82 68 10/27/2017
0.9.81 22 10/27/2017
0.9.80 40 10/26/2017
0.9.79 60 10/26/2017
0.9.78 18 10/26/2017
0.9.77 239 10/24/2017
0.9.76 43 10/24/2017
0.9.75 14 10/24/2017
0.9.74 4 10/24/2017
0.9.73 509 10/19/2017
0.9.72 371 10/18/2017
0.9.71 83 10/17/2017
0.9.70 436 10/12/2017
0.9.69 192 10/11/2017
0.9.68 337 10/10/2017
0.9.67 125 10/9/2017
0.9.65 180 10/6/2017
0.9.64 173 10/5/2017
0.9.63 312 10/4/2017
0.9.62 701 9/30/2017
0.9.61 21 9/30/2017
0.9.60 175 9/28/2017
0.9.59 180 9/28/2017
0.9.58 67 9/27/2017
0.9.57 487 9/26/2017
0.9.56 437 9/25/2017
0.9.55 8 9/25/2017
0.9.54 36 9/25/2017
0.9.53 83 9/22/2017
0.9.52 46 9/22/2017
0.9.51 52 9/22/2017
0.9.50 8 9/22/2017
0.9.49 101 9/20/2017
0.9.48 122 9/19/2017
0.9.47 13 9/19/2017
0.9.46 38 9/19/2017
0.9.45 114 9/18/2017
0.9.44 163 9/14/2017
0.9.43 4 9/14/2017
0.9.42 417 9/13/2017
0.9.41 523 9/7/2017
0.9.40 169 9/6/2017
0.9.39 524 8/27/2017
0.9.38 11 8/26/2017
0.9.37 5 8/26/2017
0.9.34 427 8/18/2017
0.9.33 9 8/18/2017
0.9.32 4 8/18/2017
0.9.31 86 8/17/2017
0.9.30 5 8/17/2017
0.9.29 211 8/14/2017
0.9.28 85 8/14/2017
0.9.27 67 8/11/2017
0.9.26 16 8/11/2017
0.9.25 208 8/9/2017
0.9.24 239 8/4/2017
0.9.23 45 8/4/2017
0.9.22 367 7/30/2017
0.9.21 13 7/29/2017
0.9.20 153 7/27/2017
0.9.19 120 7/26/2017
0.9.18 211 7/23/2017
0.9.17 12 7/23/2017
0.9.16 7 7/23/2017
0.9.15 19 7/22/2017
0.9.12 14 7/22/2017
0.9.11 11 7/21/2017
0.9.10 70 7/21/2017
0.9.9 46 7/20/2017
0.9.7 30 7/20/2017
0.9.6 10 7/20/2017
0.9.4 47 7/20/2017
0.9.3 136 7/19/2017
0.8.957 2,277 5/16/2017
0.8.956 203 5/11/2017
0.8.955 152 5/9/2017
0.8.954 75 5/9/2017
0.8.953 6 5/9/2017
0.8.952 42 5/8/2017
0.8.951 67 5/8/2017
0.8.950 132 5/4/2017
0.8.948 473 4/25/2017
0.8.947 195 4/19/2017
0.8.946 7 4/19/2017
0.8.945 349 4/11/2017
0.8.944 479 3/29/2017
0.8.943 217 3/22/2017
0.8.942 303 3/15/2017
0.8.941 11 3/15/2017
0.8.940 113 3/10/2017
0.8.939 32 3/10/2017
0.8.938 223 3/5/2017
0.8.937 95 3/4/2017
0.8.935 23 3/4/2017
0.8.934 8 3/4/2017
0.8.933 159 3/1/2017
0.8.932 7 3/1/2017
0.8.931 92 2/28/2017
0.8.930 63 2/27/2017
0.8.929 47 2/27/2017
0.8.928 51 2/24/2017
0.8.925 19 2/24/2017
0.8.920 23 2/24/2017
0.8.915 12 2/24/2017
0.8.914 31 2/24/2017
0.8.912 6 2/24/2017
0.8.910 11 2/23/2017
0.8.908 12 2/23/2017
0.8.905 32 2/23/2017
0.8.904 33 2/22/2017
0.8.903 217 2/20/2017
0.8.902 73 2/18/2017
0.8.901 150 2/15/2017
0.8.900 142 2/13/2017
0.8.709 152 2/8/2017
0.8.708 16 2/8/2017
0.8.707 46 2/7/2017
0.8.705 55 2/7/2017
0.8.704 5 2/7/2017
0.8.702 18 2/6/2017
0.8.701 20 2/6/2017
0.8.700 31 2/5/2017
0.8.695 16 2/4/2017
0.8.694 120 2/1/2017
0.8.692 908 12/16/2016
0.8.691 68 12/14/2016
0.8.69 29 12/13/2016
0.8.68 230 11/30/2016
0.8.66 66 11/27/2016
0.8.65 95 11/22/2016
0.8.61 262 11/2/2016
0.8.6 (current version) 88 10/29/2016
0.8.5.56 362 9/26/2016
0.8.5.55 20 9/26/2016
0.8.5.53 291 8/20/2016
0.8.5.52 47 8/18/2016
0.8.5.51 7 8/18/2016
0.8.5.50 25 8/17/2016
0.8.5.5 7 8/17/2016
0.8.5.3 16 8/16/2016
0.8.5.2 15 8/16/2016
0.8.4.8 125 7/29/2016
0.8.4.7 9 7/28/2016
0.8.4.6 27 7/25/2016
0.8.4.4 31 7/23/2016
0.8.4.1 42 7/20/2016
0.8.4.0 12 7/20/2016
0.8.3.5 15 7/18/2016
0.8.3.4 18 7/18/2016
0.8.3.3 7 7/17/2016
0.8.3.2 10 7/17/2016
0.8.3.1 7 7/17/2016
0.8.3.0 7 7/17/2016
0.8.2.9 7 7/17/2016
0.8.2.8 7 7/17/2016
0.8.2.7 10 7/16/2016
0.8.2.6 7 7/16/2016
0.8.2.5 13 7/15/2016
0.8.2.4 7 7/15/2016
0.8.1.9 47 7/5/2016
0.8.1.8 32 6/28/2016
0.8.1.7 29 6/23/2016
0.8.1.5 35 6/18/2016
0.8.1.3 21 6/14/2016
0.8.1.2 12 6/14/2016
0.8.1.1 7 6/14/2016
0.8.1.0 28 6/4/2016
0.8.0.8 39 5/21/2016
0.8.0.7 7 5/21/2016
0.8.0.6 17 5/17/2016
0.8.0.5 9 5/16/2016
0.8.0.4 6 5/16/2016
0.8.0.2 7 5/16/2016
0.8.0.1 8 5/16/2016
0.8.0.0 9 5/16/2016
0.7.9.9 7 5/15/2016
0.7.9.8 11 5/15/2016
0.7.9.7 9 5/15/2016
Show less