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.427 248 9/18/2018
0.9.425 17 9/18/2018
0.9.424 69 9/18/2018
0.9.423 7 9/18/2018
0.9.422 337 9/16/2018
0.9.421 4 9/16/2018
0.9.420 10 9/16/2018
0.9.419 340 9/14/2018
0.9.418 924 9/11/2018
0.9.417 550 9/9/2018
0.9.415 125 9/8/2018
0.9.412 50 9/7/2018
0.9.411 265 9/7/2018
0.9.410 68 9/7/2018
0.9.405 2 9/7/2018
0.9.402 307 9/6/2018
0.9.400 365 9/5/2018
0.9.399 627 8/31/2018
0.9.398 209 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,416 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 709 7/18/2018
0.9.375 694 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 120 7/3/2018
0.9.363 376 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 69 6/25/2018
0.9.357 632 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 90 6/19/2018
0.9.351 64 6/19/2018
0.9.350 9 6/19/2018
0.9.349 664 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 960 2/28/2018
0.9.211 286 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 50 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 79 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 790 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 210 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,275 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 18 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 46 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 7 5/15/2016
Show less