dbatools

0.9.419

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

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