SqlServerTools

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

• • SqlServer (>= 22.3.0)

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.