Azure SQL database availability after creation

Question

I'm trying to configure an Azure pipeline where I create a copy of a production database to create a "pre-prod" environment.

After create that database I need to run some queries in the freshly created database. The problem is database is not available right away. As the process is automatic I need to know for how long I need to wait.

I put a wait step for 5 minutes but sometimes is not enough.

Thanks in advance

Gelásio · Accepted Answer · 2020-09-16 11:09:31Z

1

How about using a simple check of DB availability, through Az module, or CLI?

do {
  sleep 120
  $status = "Offline"
  try{
    $status = (Get-AzSqlDatabase -ResourceGroupName "resourcegroup01" -ServerName "server01"-DatabaseName "MyDataBase").Status
  }
  catch
  {
    "Database not available yet"
  }
} while ($status -ne "Online")

edited Sep 16, 2020 at 11:09

Gelásio

1,9091 gold badge19 silver badges18 bronze badges

answered Sep 8, 2020 at 13:34

Oleh Tarasenko

6105 silver badges19 bronze badges

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

4 Comments

Gelásio Over a year ago

I use your base idea to solve my problem (I already request some changes in your answer to match what I do). I use Azure PowerShell.

Hugh Lin Over a year ago

@Gelásio Can you share your changes here? I will help you update these changes into Oleh Tarasenko's answer.

Oleh Tarasenko Over a year ago

I don't see any request for edit, @Gelásio can you please write what is need to be changed. Thank you!

Gelásio Over a year ago

I already try another time. I don't know why my first request for edit simply disappear. Here it is my second try: stackoverflow.com/review/suggested-edits/27175641

Hugh Lin · Accepted Answer · 2020-09-09 06:41:22Z

0

You can try to use the Azure portal's query editor to query an Azure SQL Database to check DB availability.

The query editor is a tool in the Azure portal for running SQL queries against your database in Azure SQL Database or data warehouse in Azure Synapse Analytics.

Note: The query editor uses ports 443 and 1443 to communicate. Ensure you have enabled outbound HTTPS traffic on these ports. You also need to add your outbound IP address to the server's allowed firewall rules to access your databases and data warehouses.

For more query editor considerations, please refer to this.

answered Sep 9, 2020 at 6:41

Hugh Lin

19.8k3 gold badges30 silver badges33 bronze badges

Collectives™ on Stack Overflow

Azure SQL database availability after creation

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related