dbatools

0.9.420

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

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.87 345 1/23/2020
1.0.86 67 1/23/2020
1.0.85 2,018 1/20/2020
1.0.84 888 1/17/2020
1.0.83 3,086 1/10/2020
1.0.82 129 1/10/2020
1.0.81 1,188 1/8/2020
1.0.80 962 1/6/2020
1.0.79 870 1/3/2020
1.0.78 695 1/1/2020
1.0.77 2,480 12/20/2019
1.0.76 88 12/20/2019
1.0.75 5,433 12/7/2019
1.0.74 2,797 12/2/2019
1.0.73 3,679 11/22/2019
1.0.72 2,552 11/19/2019
1.0.71 1,816 11/14/2019
1.0.70 59 11/14/2019
1.0.69 74 11/14/2019
1.0.68 1,794 11/11/2019
1.0.67 2,733 11/5/2019
1.0.66 569 11/4/2019
1.0.65 810 11/1/2019
1.0.64 1,823 10/29/2019
1.0.63 11 10/29/2019
1.0.62 630 10/28/2019
1.0.61 1,383 10/24/2019
1.0.60 944 10/22/2019
1.0.59 390 10/21/2019
1.0.58 358 10/20/2019
1.0.57 265 10/18/2019
1.0.56 82 10/18/2019
1.0.55 174 10/18/2019
1.0.54 844 10/16/2019
1.0.53 967 10/15/2019
1.0.52 4,377 10/7/2019
1.0.51 2,010 10/1/2019
1.0.50 1,844 9/26/2019
1.0.49 1,543 9/24/2019
1.0.48 753 9/23/2019
1.0.47 754 9/20/2019
1.0.46 2,833 9/14/2019
1.0.45 812 9/13/2019
1.0.44 394 9/12/2019
1.0.43 1,751 9/10/2019
1.0.42 26,263 9/8/2019
1.0.41 308 9/7/2019
1.0.40 1,244 9/5/2019
1.0.39 898 9/4/2019
1.0.38 4,030 8/28/2019
1.0.37 164 8/28/2019
1.0.36 626 8/27/2019
1.0.35 2,355 8/22/2019
1.0.34 1,715 8/19/2019
1.0.33 1,454 8/15/2019
1.0.32 627 8/14/2019
1.0.31 39 8/14/2019
1.0.30 2,058 8/8/2019
1.0.29 2,036 8/2/2019
1.0.28 476 8/1/2019
1.0.27 604 7/31/2019
1.0.26 979 7/29/2019
1.0.25 361 7/28/2019
1.0.23 2,510 7/22/2019
1.0.22 6,467 7/16/2019
1.0.21 1,701 7/11/2019
1.0.20 839 7/10/2019
1.0.19 331 7/9/2019
1.0.18 23 7/9/2019
1.0.17 464 7/9/2019
1.0.16 7 7/9/2019
1.0.15 914 7/5/2019
1.0.14 502 7/4/2019
1.0.13 91 7/4/2019
1.0.12 1,484 7/1/2019
1.0.11 305 7/1/2019
1.0.10 300 6/29/2019
1.0.9 2,181 6/26/2019
1.0.8 96 6/26/2019
1.0.7 21 6/26/2019
1.0.6 14,780 6/25/2019
1.0.5 886 6/24/2019
1.0.4 466 6/23/2019
1.0.3 49 6/23/2019
1.0.2 546 6/21/2019
1.0.1 119 6/21/2019
1.0.0 939 6/20/2019
0.9.834 210,910 5/30/2019
0.9.833 200 5/30/2019
0.9.832 2,002 5/24/2019
0.9.831 871 5/22/2019
0.9.830 1,156 5/20/2019
0.9.829 908 5/17/2019
0.9.828 1,241 5/15/2019
0.9.827 391 5/14/2019
0.9.826 568 5/13/2019
0.9.825 975 5/10/2019
0.9.824 256 5/9/2019
0.9.823 791 5/8/2019
0.9.822 967 5/6/2019
0.9.821 1,525 5/2/2019
0.9.819 725 5/1/2019
0.9.818 289 4/30/2019
0.9.817 159 4/30/2019
0.9.815 203 4/29/2019
0.9.814 124 4/29/2019
0.9.812 442 4/27/2019
0.9.811 585 4/25/2019
0.9.810 252 4/25/2019
0.9.809 1,373 4/20/2019
0.9.808 560 4/18/2019
0.9.807 327 4/17/2019
0.9.805 12 4/17/2019
0.9.804 1,452 4/14/2019
0.9.803 1,515 4/10/2019
0.9.802 1,281 4/6/2019
0.9.801 646 4/4/2019
0.9.800 1,399 4/1/2019
0.9.799 520 3/30/2019
0.9.798 949 3/28/2019
0.9.797 1,236 3/26/2019
0.9.795 631 3/23/2019
0.9.794 175 3/22/2019
0.9.793 95 3/20/2019
0.9.792 206 3/20/2019
0.9.791 731 3/18/2019
0.9.790 179 3/18/2019
0.9.789 192 3/18/2019
0.9.788 98 3/18/2019
0.9.787 127 3/17/2019
0.9.785 150 3/16/2019
0.9.784 2,460 3/11/2019
0.9.783 49 3/11/2019
0.9.782 496 3/10/2019
0.9.781 338 3/8/2019
0.9.780 700 3/7/2019
0.9.779 580 3/5/2019
0.9.778 143 3/5/2019
0.9.777 568 3/4/2019
0.9.775 1,803 2/26/2019
0.9.774 170 2/26/2019
0.9.773 669 2/24/2019
0.9.772 83 2/24/2019
0.9.771 1,747 2/20/2019
0.9.770 869 2/16/2019
0.9.758 6 2/16/2019
0.9.757 1,320 2/12/2019
0.9.755 848 2/9/2019
0.9.754 1,054 2/7/2019
0.9.753 436 2/6/2019
0.9.752 1,402 2/3/2019
0.9.751 735 1/31/2019
0.9.750 1,695 1/25/2019
0.9.749 236 1/24/2019
0.9.748 237 1/24/2019
0.9.747 241 1/23/2019
0.9.745 136 1/23/2019
0.9.744 91 1/23/2019
0.9.743 853 1/20/2019
0.9.742 1,535 1/15/2019
0.9.741 701 1/11/2019
0.9.740 94 1/11/2019
0.9.739 151 1/11/2019
0.9.738 213 1/10/2019
0.9.737 645 1/8/2019
0.9.735 398 1/7/2019
0.9.734 3,462 1/2/2019
0.9.733 425 12/31/2018
0.9.732 682 12/26/2018
0.9.731 343 12/23/2018
0.9.730 477 12/21/2018
0.9.729 21 12/21/2018
0.9.728 13 12/21/2018
0.9.725 252 12/20/2018
0.9.724 168 12/20/2018
0.9.722 405 12/19/2018
0.9.721 518 12/18/2018
0.9.720 587 12/16/2018
0.9.719 84 12/15/2018
0.9.718 185 12/14/2018
0.9.717 128 12/14/2018
0.9.715 363 12/12/2018
0.9.714 788 12/10/2018
0.9.712 293 12/9/2018
0.9.711 484 12/7/2018
0.9.710 539 12/5/2018
0.9.709 660 12/4/2018
0.9.708 29 12/4/2018
0.9.707 24 12/3/2018
0.9.705 66 12/3/2018
0.9.704 330 12/3/2018
0.9.703 58 12/2/2018
0.9.702 54 12/2/2018
0.9.701 2,966 12/1/2018
0.9.700 7 12/1/2018
0.9.538 251 11/30/2018
0.9.537 131 11/30/2018
0.9.535 171 11/29/2018
0.9.534 174 11/29/2018
0.9.533 670 11/27/2018
0.9.532 474 11/26/2018
0.9.531 421 11/24/2018
0.9.530 26 11/24/2018
0.9.528 22 11/24/2018
0.9.527 108 11/23/2018
0.9.525 25 11/23/2018
0.9.524 13 11/23/2018
0.9.523 75 11/23/2018
0.9.522 72 11/23/2018
0.9.521 222 11/22/2018
0.9.520 166 11/22/2018
0.9.519 1,449 11/17/2018
0.9.518 236 11/16/2018
0.9.517 265 11/15/2018
0.9.515 62 11/15/2018
0.9.512 667 11/14/2018
0.9.511 31 11/14/2018
0.9.510 89 11/14/2018
0.9.509 681 11/12/2018
0.9.508 243 11/12/2018
0.9.507 308 11/9/2018
0.9.505 7 11/9/2018
0.9.504 602 11/8/2018
0.9.503 192 11/7/2018
0.9.502 150 11/7/2018
0.9.501 900 11/5/2018