Powershell und SQL na wie geht das denn?
[Pages:15]Powershell und SQL ? na wie geht das denn?
Holger Voges
CCA,MCSE, MCDBA, MCT, MCITP DB Administrator / DB Developer, MCTIP Enterprise Administrator, MCSE Windows Server 2012
Netz-Weise Freundallee 13a 30173 Hannover z-weise.de
SQL-Server Powershell Modul
? Microsoft Feature Pack:
? SQLSysClrTypes.msi ? ShareManagementObjects.msi ? PowerShellTools.msi
PS:> Import-Module ?name sqlps
Invoke-Sqlcmd
? sqlcmd.exe auf Powershell ? Liefert Daten als Objekte zur?ck
Invoke-Sqlcmd ?query ,,select * from AdventureWorks2012.Person.Address" ?ServerInstance .
Neu, nicht mit Perwoll geschaffen
Add-SqlFirewallRule Get-SqlDatabase Get-SqlInstance Get-SqlSmartAdmin New-SqlBackupEncryptionOption Remove-SqlFirewallRule Set-SqlAuthenticationMode Set-SqlNetworkConfiguration Set-SqlSmartAdmin Start-SqlInstance Stop-SqlInstance Test-SqlSmartAdmin
Commandlets f?r Always on
CommandType ----------Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet
Name ---Add-SqlAvailabilityDatabase Add-SqlAvailabilityGroupListenerStaticIp Join-SqlAvailabilityGroup New-SqlAvailabilityGroup New-SqlAvailabilityGroupListener New-SqlAvailabilityReplica Remove-SqlAvailabilityDatabase Remove-SqlAvailabilityGroup Remove-SqlAvailabilityReplica Resume-SqlAvailabilityDatabase Set-SqlAvailabilityGroup Set-SqlAvailabilityGroupListener Set-SqlAvailabilityReplica Suspend-SqlAvailabilityDatabase Switch-SqlAvailabilityGroup Test-SqlAvailabilityGroup Test-SqlAvailabilityReplica Disable-SqlAlwaysOn Enable-SqlAlwaysOn
ModuleName ---------sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps sqlps
Weitere Commandlets
CommandType ----------Cmdlet Cmdlet Cmdlet cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet
Name ---Add-SqlFirewallRule Backup-SqlDatabase Convert-UrnToPath Decode-SqlName Encode-SqlName Get-SqlCredential Get-SqlDatabase Get-SqlInstance Get-SqlSmartAdmin Invoke-PolicyEvaluation Invoke-Sqlcmd New-SqlBackupEncryptionOption New-SqlCredential New-SqlHADREndpoint
CommandType ----------Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet Cmdlet
Name ---Remove-SqlCredential Remove-SqlFirewallRule Restore-SqlDatabase Set-SqlAuthenticationMode Set-SqlCredential Set-SqlHADREndpoint Set-SqlNetworkConfiguration Set-SqlSmartAdmin Start-SqlInstance Stop-SqlInstance Test-SqlDatabaseReplicaState Test-SqlSmartAdmin
Sql Server Managed Backup f?r Azure
cd SQLSERVER:\SQL\Computer\MyInstance $encryptionOption = New-SqlBackupEncryptionOption -EncryptionAlgorithm Aes128 -EncryptorType ServerCertificate -EncryptorName "MyBackupCert" Get-SqlSmartAdmin | Set-SqlSmartAdmin ?BackupEnabled $True ?BackupRetentionPeriodInDays 10 EncryptionOption $encryptionOption
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- powershell import sql module
- und emergency federal aid grant
- powershell invoke sql command
- powershell query sql table
- powershell execute sql command
- powershell list sql server instances
- powershell execute sql file
- powershell run sql script
- powershell query sql server
- powershell query sql server database
- powershell execute sql server query
- powershell execute sql query