SqlServerTools

Author(s)

• Robert Eder

Tags

SQLServerClient Smo SQLManagementObjects

Functions

Add-SmoDatabaseAsymmetricKeyPrivateKey Add-SmoDatabaseCertificatePrivateKey Add-SmoDatabaseDataFile Add-SmoDatabaseMasterKeyPasswordEncryption Add-SmoDatabaseMasterKeyServiceKeyEncryption Add-SmoDatabaseRoleMember Add-SmoDatabaseSymmetricKeyKeyEncryption Add-SmoServerRoleMember Clear-SmoDatabaseQueryStore Close-SmoDatabaseMasterKey Close-SmoDatabaseSymmetricKey Connect-SmoServer Disable-SmoDatabaseQueryStore Disable-SmoTransparentDatabaseEncryption Disconnect-SmoServer Enable-SmoDatabaseQueryStore Enable-SmoTransparentDatabaseEncryption Export-SmoDatabaseCertificate Export-SmoDatabaseMasterKey Export-SmoServiceMasterKey Get-SmoBackupFileList Get-SmoBackupHeader Get-SmoDatabaseAsymmetricKey Get-SmoDatabaseCertificate Get-SmoDatabaseDataFile Get-SmoDatabaseEncryptionKey Get-SmoDatabaseFileGroup Get-SmoDatabaseMasterKey Get-SmoDatabaseObject Get-SmoDatabaseQueryStore Get-SmoDatabaseRole Get-SmoDatabaseRoleMember Get-SmoDatabaseSchema Get-SmoDatabaseSymmetricKey Get-SmoDatabaseSymmetricKeyKeyEncryption Get-SmoDatabaseUser Get-SmoServerRole Get-SmoServerRoleMember Get-SmoSqlLogin Import-SmoDatabaseMasterKey Import-SmoServiceMasterKey Invoke-SmoNonQuery Invoke-SmoScriptDatabase Invoke-SmoScriptDatabaseObject Invoke-SmoScriptServerObject 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-SmoCredential Remove-SmoDatabaseAsymmetricKey Remove-SmoDatabaseAsymmetricKeyPrivateKey Remove-SmoDatabaseCertificate Remove-SmoDatabaseDataFile Remove-SmoDatabaseEncryptionKey Remove-SmoDatabaseFileGroup 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-SmoDatabaseDataFile Set-SmoDatabaseEncryptionKey Set-SmoDatabaseFileGroup Set-SmoDatabaseObjectPermission Set-SmoDatabasePermission Set-SmoDatabaseQueryStore 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.