Azure SQL database PowerShell

Question

I am trying to create a PowerShell script that loops through each user database in Azure SQL server supplied as a parameter and enable the TDE and return the status.

How can I create a PowerShell script for that? Can you show me some examples?

Thank you

itaysk · Accepted Answer · 2016-10-16 22:37:11Z

0

Use the Set-AzureRmSqlDatabaseTransparentDataEncryption cmdlet

answered Oct 16, 2016 at 22:37

itaysk

6,3642 gold badges38 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jk2016 Over a year ago

Thanks ,but How can I loop through each database one at the time to execute Set-AzureRmSqlDatabaseTransparentDataEncryption in powershell script?

jk2016 Over a year ago

I have something like this so far to loop though azure sql user databases in a server,,,, I am not sure how to loop through databases one at the time Login-AzureRMAccount $AzureSQLServer = Get-AzureRmSqlServer -ResourceGroupName $AzureSQLdatabases =Get-AzureRmSqlDatabase -ResourceGroupName "test" -ServerName $AzureSQLServer $AzureSQLDatabase= ?? singledatabe # loop through each user databases in Azure SQL Server foreach ($AzureSQLDatabase in $AzureSQLdatabases) { Set-AzureRMSqlDatabaseTransparentDataEncryption -State 'Enabled' }

itaysk Over a year ago

Do you successfully get the $AzureSQLdatabases variable? If so, then the only thing I see missing is to specify the DB to operate on. delete the line where you have $AzureSQLDatabase= ?? singledatabe and in the line inside the loop, pipe the current DB to the cmdlet like so $AzureSQLDatabase | Set-AzureRMSqlDatabaseTransparentDataEncryption -State Enabled.

Francesco Mantovani · Accepted Answer · 2022-09-06 13:29:15Z

0

You can iterate through each database this way: Azure PowerShell - Extracting Azure SQL Database information

Then change the code and adapt it to TDE.

answered Sep 6, 2022 at 13:29

Francesco Mantovani

12.8k20 gold badges104 silver badges178 bronze badges

Collectives™ on Stack Overflow

Azure SQL database PowerShell

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related