SqlServerTools

3.6.1.2

Module provides SQL Server Client and SQL Management Object (SMO) functions.

Minimum PowerShell version

5.1

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SqlServerTools

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name SqlServerTools

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy 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

Owners

Copyright

(c) 2021 Robert Eder. All rights reserved.

Package Details

Author(s)

  • Robert Eder

Tags

SQLServerClient Smo SQLManagementObjects

Functions

Add-SmoAvailabilityDatabase Add-SmoDatabaseAsymmetricKeyPrivateKey Add-SmoDatabaseDataFile Add-SmoDatabaseMasterKeyPasswordEncryption Add-SmoDatabaseMasterKeyServiceKeyEncryption Add-SmoDatabaseRoleMember Add-SmoDatabaseSymmetricKeyKeyEncryption Add-SmoServerRoleMember Close-SmoDatabaseMasterKey Close-SmoDatabaseSymmetricKey Connect-SmoServer Disable-SmoTransparentDatabaseEncryption Disconnect-SmoServer Enable-SmoTransparentDatabaseEncryption Export-SmoDatabaseCertificate Export-SmoDatabaseMasterKey Export-SmoServiceMasterKey Get-SmoAvailabilityGroup Get-SmoBackupFileList Get-SmoBackupHeader Get-SmoDatabaseAsymmetricKey Get-SmoDatabaseCertificate Get-SmoDatabaseEncryptionKey Get-SmoDatabaseMasterKey Get-SmoDatabaseObject Get-SmoDatabaseSymmetricKey Import-SmoDatabaseMasterKey Import-SmoServiceMasterKey Invoke-SmoNonQuery New-SmoCredential New-SmoDatabaseAsymmetricKey New-SmoDatabaseCertificate New-SmoDatabaseEncryptionKey New-SmoDatabaseFileGroup New-SmoDatabaseMasterKey New-SmoDatabaseRole New-SmoDatabaseSchema New-SmoDatabaseSymmetricKey New-SmoDatabaseUser New-SmoServerRole New-SmoSqlLogin Open-SmoDatabaseMasterKey Open-SmoDatabaseSymmetricKey Remove-SmoAvailabilityDatabase Remove-SmoCredential Remove-SmoDatabaseAsymmetricKey Remove-SmoDatabaseAsymmetricKeyPrivateKey Remove-SmoDatabaseCertificate Remove-SmoDatabaseEncryptionKey Remove-SmoDatabaseMasterKey Remove-SmoDatabaseMasterKeyPasswordEncryption Remove-SmoDatabaseMasterKeyServiceKeyEncryption Remove-SmoDatabaseRole Remove-SmoDatabaseRoleMember Remove-SmoDatabaseSchema Remove-SmoDatabaseSymmetricKey Remove-SmoDatabaseSymmetricKeyKeyEncryption Remove-SmoDatabaseUser Remove-SmoServerRole Remove-SmoServerRoleMember Remove-SmoSqlLogin Rename-SmoDatabaseDataFile Rename-SmoDatabaseLogFile Reset-SmoDatabaseEncryptionKey Reset-SmoDatabaseMasterKey Reset-SmoServiceMasterKey Set-SmoCredential Set-SmoDatabaseAsymmetricKey Set-SmoDatabaseCertificate Set-SmoDatabaseEncryptionKey Set-SmoDatabaseObjectPermission Set-SmoDatabasePermission Set-SmoDatabaseRole Set-SmoDatabaseSchema Set-SmoDatabaseUser Set-SmoServerRole Set-SmoSqlLogin Build-SqlClientConnectionString Connect-SqlServerInstance Disconnect-SqlServerInstance Get-SqlClientDataSet Invoke-SqlClientBulkCopy Invoke-SqlClientNonQuery Publish-SqlDatabaseDacPac Save-SqlClientDataSet Test-SqlBrowserConnection Test-SqlConnection

PSEditions

Core Desktop

Dependencies

Release Notes

Release Notes

Known Issues:
Add-SmoDatabaseSymmetricKeyKeyEncryption - Returns an error indicating symmetric key not open despite key being open.
Open-SmoDatabaseSymmetricKey - Does not always open symmetric key.
Remove-SmoDatabaseSymmetricKeyKeyEncryption - Returns an error indicating symmetric key not open despite key being open.

FileList

Version History

Version Downloads Last updated
3.6.1.2 (current version) 19 9/19/2025
3.5.0.0 54 12/16/2024
3.4.0.1 33 7/28/2024