dbatools

0.9.421

The community module that enables SQL Server Pros to automate database development and server administration

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.9.421

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

2018 Chrissy LeMaire

Owners

Tags

sqlserver migrations sql dba databases

Cmdlets

Select-DbaObject

Functions

Start-DbaMigration Copy-DbaDatabase Copy-DbaLogin Copy-DbaAgentServer Copy-DbaSpConfigure Copy-DbaLinkedServer Copy-DbaDbMail Copy-DbaDbAssembly Copy-DbaPolicyManagement Copy-DbaAgentSharedSchedule Copy-DbaAgentOperator Copy-DbaAgentJob Copy-DbaDataCollector Copy-DbaCustomError Copy-DbaServerAuditSpecification Copy-DbaEndpoint Copy-DbaServerAudit Copy-DbaServerRole Copy-DbaResourceGovernor Copy-DbaExtendedEvent Copy-DbaBackupDevice Copy-DbaServerTrigger Copy-DbaCredential Copy-DbaCentralManagementServer Copy-DbaSysDbUserObject Copy-DbaAgentProxyAccount Copy-DbaAgentAlert Import-DbaSpConfigure Export-DbaSpConfigure Get-DbaDetachedDatabaseInfo Restore-DbaBackupFromDirectory Test-DbaConnection Import-DbaCsvToSql Copy-DbaAgentCategory Update-Dbatools Test-DbaPath Export-DbaLogin Reset-DbaAdmin Watch-DbaDbLogin Expand-DbaTLogResponsibly Test-DbaMigrationConstraint Get-DbaRegisteredServer Test-DbaNetworkLatency Find-DbaDuplicateIndex Show-DbaServerFileSystem Get-DbaDiskSpace Remove-DbaDatabaseSafely Show-DbaDbList Set-DbaTempdbConfig Test-DbaTempdbConfig Repair-DbaOrphanUser Remove-DbaOrphanUser Find-DbaUnusedIndex Test-DbaDiskAllocation Test-DbaPowerPlan Set-DbaPowerPlan Test-DbaDiskAlignment Get-DbaDbSpace Get-DbaClusterNode Test-DbaDbOwner Set-DbaDbOwner Test-DbaJobOwner Set-DbaJobOwner Test-DbaDbVirtualLogFile Get-DbaRestoreHistory Get-DbaTcpPort Test-DbaDbCompatibility Test-DbaDbCollation Test-DbaConnectionAuthScheme Test-DbaServerName Repair-DbaServerName Stop-DbaProcess Copy-DbaSsisCatalog Find-DbaOrphanedFile Get-DbaAvailabilityGroup Get-DbaLastGoodCheckDb Get-DbaProcess Get-DbaRunningJob Set-DbaMaxDop Test-DbaRecoveryModel Test-DbaMaxDop Remove-DbaBackup Get-DbaPermission Get-DbaLastBackup Connect-DbaInstance Get-DbaStartupParameter Get-DbaBackupHistory Read-DbaBackupHeader Test-DbaLastBackup Get-DbaMaxMemory Set-DbaMaxMemory Test-DbaMaxMemory Get-DbaDbSnapshot Remove-DbaDbSnapshot Get-DbaRoleMember Resolve-DbaNetworkName Test-DbaWindowsLogin Get-DbaMemoryUsage Export-DbaAvailabilityGroup Write-DbaDataTable New-DbaDbSnapshot Restore-DbaDbSnapshot Get-DbaServerTrigger Get-DbaDbTrigger Export-DbaUser Get-DbaDbState Set-DbaDbState Get-DbaHelpIndex Get-DbaAgentAlert Get-DbaAgentOperator Get-DbaPageFileSetting Get-DbaSpConfigure Rename-DbaLogin Find-DbaAgentJob Find-DbaDatabase Get-DbaMsdtc Get-DbaUptime Get-DbaXESession Test-DbaOptimizeForAdHoc Find-DbaStoredProcedure Measure-DbaBackupThroughput Find-DbaLoginInGroup Get-DbaSpn Test-DbaSpn Set-DbaSpn Remove-DbaSpn Get-DbaDatabase Find-DbaUserObject Get-DbaService Get-DbaDependency Clear-DbaConnectionPool Find-DbaCommand Get-DbatoolsConfig Get-DbatoolsConfigValue Set-DbatoolsConfig Get-DbaClientProtocol Backup-DbaDatabase New-DbaDirectory Get-DbaPrivilege Install-DbaWatchUpdate Watch-DbaUpdate Uninstall-DbaWatchUpdate Get-DbaDbQueryStoreOption Set-DbaDbQueryStoreOption Restore-DbaDatabase Copy-DbaQueryStoreConfig Get-DbaExecutionPlan Export-DbaExecutionPlan Get-DbaServerProtocol Get-DbaLocaleSetting Get-DbaBuildReference Set-DbaSpConfigure Test-DbaIdentityUsage Get-DbaDbAssembly Get-DbaAgentJob Get-DbaCustomError Get-DbaCredential Get-DbaBackupDevice Get-DbaAgentProxy Get-DbaDbEncryption New-DbaSsisCatalog Remove-DbaDatabase Get-DbaQueryExecutionTime Get-DbaTempdbUsage Find-DbaDbGrowthEvent Get-DbaNetworkActivity Get-DbaAgentJobOutputFile Set-DbaAgentJobOutputFile Test-DbaLinkedServerConnection Get-DbaDbFile Read-DbaTransactionLog Get-DbaDbTable Invoke-DbaDbShrink Get-DbaEstimatedCompletionTime Get-DbaLinkedServer Set-DbaStartupParameter New-DbaAgentJob Export-DbaScript Get-DbaLogin New-DbaScriptingOption Save-DbaDiagnosticQueryScript Invoke-DbaDiagnosticQuery Export-DbaDiagnosticQuery Invoke-DbaWhoIsActive Install-DbaWhoIsActive Set-DbaAgentJob Remove-DbaAgentJob New-DbaAgentJobStep Set-DbaAgentJobStep Remove-DbaAgentJobStep New-DbaAgentSchedule Set-DbaAgentSchedule Remove-DbaAgentSchedule Backup-DbaDbCertificate Get-DbaDbCertificate Get-DbaCmConnection Get-DbaCmObject Get-DbaEndpoint Get-DbaDbMasterKey Get-DbaSchemaChangeHistory Get-DbaServerAudit Get-DbaServerAuditSpecification Get-DbaProductKey Get-DbatoolsLog Restore-DbaDbCertificate New-DbaDbCertificate New-DbaCmConnection New-DbaDbMasterKey New-DbaServiceMasterKey New-DbatoolsSupportPackage Remove-DbaDbCertificate Remove-DbaCmConnection Remove-DbaDbMasterKey Set-DbaCmConnection Set-DbaTcpPort Test-DbaCmConnection New-DbaConnectionStringBuilder Get-DbaInstanceProperty Get-DbaInstanceUserOption New-DbaConnectionString Get-DbaAgentSchedule Invoke-DbaLogShipping Read-DbaTraceFile New-DbaComputerCertificate Get-DbaComputerCertificate Add-DbaComputerCertificate Get-DbaNetworkCertificate Set-DbaNetworkCertificate Remove-DbaNetworkCertificate Enable-DbaForceNetworkEncryption Disable-DbaForceNetworkEncryption Get-DbaForceNetworkEncryption Remove-DbaComputerCertificate Get-DbaServerInstallDate Install-DbaFirstResponderKit Backup-DbaDbMasterKey Get-DbaAgentJobHistory Get-DbaSsisEnvironmentVariable Get-DbaManagementObject Test-DbaManagementObject Get-DbaMaintenanceSolutionLog Invoke-DbaLogShippingRecovery Find-DbaTrigger Find-DbaView Invoke-DbaDbUpgrade Get-DbaDbUser Get-DbaWindowsLog Get-DbaErrorLog Get-DbaAgentLog Get-DbaDbMailLog Get-DbaDbMailHistory Get-DbaDbView Get-DbaDbUdf Get-DbaDbPartitionFunction Get-DbaDbPartitionScheme Get-DbaDefaultPath Get-DbaDbStoredProcedure Test-DbaDbCompression Mount-DbaDatabase Dismount-DbaDatabase Set-DbaPrivilege Get-DbaAgReplica Get-DbaAgDatabase Get-DbaModule Get-DbaRegisteredServerStore Sync-DbaLoginPermission Invoke-Sqlcmd2 New-DbaCredential Get-DbaFile Set-DbaDbCompression New-DbaClientAlias Get-DbaClientAlias Get-DbaOperatingSystem Install-DbaMaintenanceSolution Get-DbaComputerSystem Get-DbaTraceFlag Stop-DbaService Start-DbaService Restart-DbaService Invoke-DbaCycleErrorLog Get-DbaRegistryRoot Get-DbaAvailableCollation Get-DbaUserPermission Get-DbaAgHadr Find-DbaSimilarTable Disable-DbaAgHadr Enable-DbaAgHadr Get-DbaTrace Get-DbaSuspectPage Get-DbaWaitStatistic Clear-DbaWaitStatistics Get-DbaTopResourceUsage New-DbaLogin Get-DbaAgListener Invoke-DbaDbClone Read-DbaXEFile Get-DbaRepDistributor Update-DbaServiceAccount Watch-DbaXESession Disable-DbaTraceFlag Enable-DbaTraceFlag Start-DbaAgentJob Stop-DbaAgentJob Remove-DbaClientAlias New-DbaAgentProxy Test-DbaLogShippingStatus Get-DbaXESessionTarget New-DbaXESmartTargetResponse New-DbaXESmartTarget Get-DbaDbVirtualLogFile Register-DbatoolsConfig Get-DbaBackupInformation Start-DbaXESession Stop-DbaXESession Set-DbaDbRecoveryModel Get-DbaDbRecoveryModel Get-DbaWaitingTask Remove-DbaDbUser Get-DbaDump Invoke-DbaAdvancedRestore Format-DbaBackupInformation Get-DbaAgentJobStep Test-DbaBackupInformation Invoke-DbaBalanceDataFiles Select-DbaBackupInformation Rename-DbaDatabase New-DbaDacProfile Publish-DbaDacPackage Export-DbaDacPackage Copy-DbaDbTableData Invoke-DbaQuery Remove-DbaLogin Get-DbaFileStream Set-DbaFileStream Get-DbaAgentJobCategory New-DbaAgentJobCategory Remove-DbaAgentJobCategory Set-DbaAgentJobCategory Get-DbaDbRole Get-DbaServerRole Find-DbaBackup Get-DbaCpuUsage Remove-DbaXESession New-DbaXESession Import-DbaXESessionTemplate Get-DbaXEStore Export-DbaXESessionTemplate New-DbaXESmartTableWriter New-DbaXESmartReplay New-DbaXESmartEmail New-DbaXESmartQueryExec Start-DbaXESmartTarget Get-DbaOrphanUser Get-DbaOpenTransaction Get-DbaLogShippingError Test-DbaBuild Get-DbaXESessionTemplate ConvertTo-DbaXESession Start-DbaTrace Stop-DbaTrace Remove-DbaTrace Set-DbaLogin Copy-DbaXESessionTemplate Get-DbaXEObject ConvertTo-DbaDataTable Find-DbaDisabledIndex Invoke-DbaPfRelog Get-DbaPfDataCollectorCounter Get-DbaPfDataCollectorCounterSample Get-DbaPfDataCollector Get-DbaPfDataCollectorSet Start-DbaPfDataCollectorSet Stop-DbaPfDataCollectorSet Export-DbaPfDataCollectorSetTemplate Get-DbaPfDataCollectorSetTemplate Import-DbaPfDataCollectorSetTemplate Remove-DbaPfDataCollectorSet Add-DbaPfDataCollectorCounter Remove-DbaPfDataCollectorCounter Get-DbaPfAvailableCounter Get-DbaXESmartTarget Remove-DbaXESmartTarget Stop-DbaXESmartTarget Get-DbaRegisteredServerGroup New-DbaDbUser Measure-DbaDiskSpaceRequirement New-DbaXESmartCsvWriter Export-DbaXECsv Invoke-DbaXeReplay Find-DbaInstance Test-DbaDiskSpeed Get-DbaDbExtentDiff Read-DbaAuditFile Get-DbaDbCompression Invoke-DbaDbDecryptObject Get-DbaDbForeignKey Get-DbaDbCheckConstraint Set-DbaAgentAlert Get-DbaFeature Get-DbaWaitResource Get-DbaDbPageInfo Get-DbaConnection Test-DbaLoginPassword Get-DbaErrorLogConfig Set-DbaErrorLogConfig Add-DbaRegisteredServer Add-DbaRegisteredServerGroup Export-DbaRegisteredServer Import-DbaRegisteredServer Move-DbaRegisteredServer Move-DbaRegisteredServerGroup Remove-DbaRegisteredServer Remove-DbaRegisteredServerGroup Get-DbaPlanCache Clear-DbaPlanCache Get-DbaSsisExecutionHistory ConvertTo-DbaTimeline Get-DbaRepPublication Test-DbaRepLatency Get-DbaDbMail Get-DbaDbMailAccount Get-DbaDbMailProfile Get-DbaDbMailConfig Get-DbaDbMailServer Export-DbaCredential Export-DbaLinkedServer Get-DbaResourceGovernor Get-DbaRgResourcePool Get-DbaRgWorkloadGroup Get-DbaRgClassifierFunction Export-DbaInstance Get-DbaPbmCategory Get-DbaPbmCategorySubscription Get-DbaPbmCondition Get-DbaPbmObjectSet Get-DbaPbmPolicy Get-DbaPbmStore Invoke-DbatoolsRenameHelper Export-DbaRepServerSetting Get-DbaRepServer

Dependencies

This module has no dependencies.

Release Notes

https://dbatools.io/releases

Version History

Version Downloads Last updated
1.0.35 1,207 8/22/2019
1.0.34 1,702 8/19/2019
1.0.33 1,448 8/15/2019
1.0.32 626 8/14/2019
1.0.31 38 8/14/2019
1.0.30 2,051 8/8/2019
1.0.29 1,923 8/2/2019
1.0.28 475 8/1/2019
1.0.27 602 7/31/2019
1.0.26 978 7/29/2019
1.0.25 356 7/28/2019
1.0.23 2,257 7/22/2019
1.0.22 2,537 7/16/2019
1.0.21 1,698 7/11/2019
1.0.20 835 7/10/2019
1.0.19 330 7/9/2019
1.0.18 22 7/9/2019
1.0.17 415 7/9/2019
1.0.16 6 7/9/2019
1.0.15 913 7/5/2019
1.0.14 399 7/4/2019
1.0.13 90 7/4/2019
1.0.12 1,447 7/1/2019
1.0.11 304 7/1/2019
1.0.10 298 6/29/2019
1.0.9 1,998 6/26/2019
1.0.8 95 6/26/2019
1.0.7 20 6/26/2019
1.0.6 6,151 6/25/2019
1.0.5 859 6/24/2019
1.0.4 463 6/23/2019
1.0.3 47 6/23/2019
1.0.2 545 6/21/2019
1.0.1 116 6/21/2019
1.0.0 931 6/20/2019
0.9.834 152,898 5/30/2019
0.9.833 196 5/30/2019
0.9.832 2,001 5/24/2019
0.9.831 869 5/22/2019
0.9.830 1,149 5/20/2019
0.9.829 906 5/17/2019
0.9.828 1,240 5/15/2019
0.9.827 389 5/14/2019
0.9.826 567 5/13/2019
0.9.825 971 5/10/2019
0.9.824 255 5/9/2019
0.9.823 789 5/8/2019
0.9.822 966 5/6/2019
0.9.821 1,524 5/2/2019
0.9.819 724 5/1/2019
0.9.818 282 4/30/2019
0.9.817 158 4/30/2019
0.9.815 202 4/29/2019
0.9.814 123 4/29/2019
0.9.812 438 4/27/2019
0.9.811 584 4/25/2019
0.9.810 251 4/25/2019
0.9.809 1,366 4/20/2019
0.9.808 558 4/18/2019
0.9.807 326 4/17/2019
0.9.805 10 4/17/2019
0.9.804 1,446 4/14/2019
0.9.803 1,513 4/10/2019
0.9.802 1,278 4/6/2019
0.9.801 644 4/4/2019
0.9.800 1,397 4/1/2019
0.9.799 518 3/30/2019
0.9.798 947 3/28/2019
0.9.797 1,233 3/26/2019
0.9.795 629 3/23/2019
0.9.794 173 3/22/2019
0.9.793 93 3/20/2019
0.9.792 204 3/20/2019
0.9.791 729 3/18/2019
0.9.790 177 3/18/2019
0.9.789 188 3/18/2019
0.9.788 96 3/18/2019
0.9.787 125 3/17/2019
0.9.785 148 3/16/2019
0.9.784 2,456 3/11/2019
0.9.783 47 3/11/2019
0.9.782 494 3/10/2019
0.9.781 336 3/8/2019
0.9.780 698 3/7/2019
0.9.779 578 3/5/2019
0.9.778 141 3/5/2019
0.9.777 566 3/4/2019
0.9.775 1,768 2/26/2019
0.9.774 168 2/26/2019
0.9.773 667 2/24/2019
0.9.772 81 2/24/2019
0.9.771 1,717 2/20/2019
0.9.770 867 2/16/2019
0.9.758 4 2/16/2019
0.9.757 1,318 2/12/2019
0.9.755 828 2/9/2019
0.9.754 1,051 2/7/2019
0.9.753 434 2/6/2019
0.9.752 1,343 2/3/2019
0.9.751 733 1/31/2019
0.9.750 1,687 1/25/2019
0.9.749 234 1/24/2019
0.9.748 235 1/24/2019
0.9.747 239 1/23/2019
0.9.745 134 1/23/2019
0.9.744 89 1/23/2019
0.9.743 849 1/20/2019
0.9.742 1,524 1/15/2019
0.9.741 699 1/11/2019
0.9.740 92 1/11/2019
0.9.739 149 1/11/2019
0.9.738 211 1/10/2019
0.9.737 643 1/8/2019
0.9.735 396 1/7/2019
0.9.734 1,464 1/2/2019
0.9.733 423 12/31/2018
0.9.732 677 12/26/2018
0.9.731 341 12/23/2018
0.9.730 475 12/21/2018
0.9.729 19 12/21/2018
0.9.728 11 12/21/2018
0.9.725 250 12/20/2018
0.9.724 165 12/20/2018
0.9.722 403 12/19/2018
0.9.721 516 12/18/2018
0.9.720 583 12/16/2018
0.9.719 81 12/15/2018
0.9.718 183 12/14/2018
0.9.717 126 12/14/2018
0.9.715 346 12/12/2018
0.9.714 786 12/10/2018
0.9.712 290 12/9/2018
0.9.711 481 12/7/2018
0.9.710 537 12/5/2018
0.9.709 658 12/4/2018
0.9.708 27 12/4/2018
0.9.707 22 12/3/2018
0.9.705 64 12/3/2018
0.9.704 328 12/3/2018
0.9.703 56 12/2/2018
0.9.702 52 12/2/2018
0.9.701 1,029 12/1/2018
0.9.700 5 12/1/2018
0.9.538 221 11/30/2018
0.9.537 129 11/30/2018
0.9.535 169 11/29/2018
0.9.534 172 11/29/2018
0.9.533 668 11/27/2018
0.9.532 459 11/26/2018
0.9.531 419 11/24/2018
0.9.530 24 11/24/2018
0.9.528 20 11/24/2018
0.9.527 106 11/23/2018
0.9.525 23 11/23/2018
0.9.524 11 11/23/2018
0.9.523 73 11/23/2018
0.9.522 70 11/23/2018
0.9.521 220 11/22/2018
0.9.520 164 11/22/2018
0.9.519 1,447 11/17/2018
0.9.518 234 11/16/2018
0.9.517 263 11/15/2018
0.9.515 60 11/15/2018
0.9.512 665 11/14/2018
0.9.511 29 11/14/2018
0.9.510 87 11/14/2018
0.9.509 669 11/12/2018
0.9.508 241 11/12/2018
0.9.507 306 11/9/2018
0.9.505 6 11/9/2018
0.9.504 600 11/8/2018
0.9.503 190 11/7/2018
0.9.502 148 11/7/2018
0.9.501 898 11/5/2018
0.9.500 247 11/3/2018
0.9.499 318 11/2/2018
0.9.498 106 11/2/2018
0.9.497 705 10/31/2018
0.9.495 300 10/30/2018
0.9.494 208 10/29/2018
0.9.493 145 10/29/2018
0.9.492 265 10/28/2018
0.9.491 460 10/26/2018
0.9.490 750 10/24/2018
0.9.489 137 10/23/2018
0.9.488 7 10/23/2018
0.9.487 1,134 10/18/2018
0.9.485 290 10/18/2018
0.9.484 867 10/16/2018
0.9.483 203 10/15/2018
0.9.482 38 10/15/2018
0.9.481 87 10/15/2018
0.9.480 46 10/15/2018
0.9.479 111 10/14/2018
0.9.478 6 10/14/2018
0.9.477 382 10/12/2018
0.9.475 230 10/11/2018
0.9.474 196 10/11/2018
0.9.473 528 10/10/2018
0.9.472 207 10/9/2018
0.9.471 577 10/8/2018
0.9.470 131 10/7/2018
0.9.459 43 10/7/2018
0.9.458 52 10/6/2018
0.9.457 44 10/6/2018
0.9.455 356 10/4/2018
0.9.454 244 10/4/2018
0.9.453 346 10/3/2018
0.9.452 13 10/3/2018
0.9.451 24 10/3/2018
0.9.450 672 10/1/2018
0.9.447 330 9/29/2018
0.9.445 662 9/26/2018