Database Migration from vCore to Standard pricing tier but Database is connected to web application

asked 2021-04-22T05:59:00.45+00:00
Shruti Gupta3 1 Reputation point

Hi Azure Team,

We have a web application for which we are using Azure SQL Database. Current pricing tier is vCore and we are planning to migrate it to Standard pricing tier DTU. Please let us know the steps. How will it affect the database connection strings?

Azure SQL Database
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2021-04-22T08:35:34.527+00:00
    SUNOJ KUMAR YELURU 12,381 Reputation points Microsoft MVP

    Hi @Shruti Gupta3

    To clarify on this once you downgrade SQL database from vCore to Standard pricing tier there is no changes to the database connection string and port number remains same.

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

  2. answered 2021-04-22T10:28:05.273+00:00
    Anurag Sharma 17,251 Reputation points

    Hi @Shruti Gupta3 , welcome to Microsoft Q&A forum.

    <Writing in answer section as it is crossing 1000 words limit of comment>

    Complementing @SUNOJ KUMAR YELURU , "Initiating scale up or scale down action in any of the flavors would restart database engine process and move it to a different virtual machine if needed. Moving database engine process to a new virtual machine is online process where you can continue using your existing Azure SQL Database service while the process is in progress. Once the target database engine is fully initialized and ready to process the queries, the connections will be switched from source to target database engine."
    Regardless, the switch can result in a brief service interruption when the database is unavailable generally for less than 30 seconds and often for only a few seconds. If any transaction happens within this brief period of time, that will be rolled back. To handle the rollback one way is to have retry logic in the application which would keep on retrying the connecting until the connection is up. If we don't have the retry logic and cannot take the risk of losing the data within those brief period, we might need to stop the service and start it again once it is up."

    Scale single database resources in Azure SQL Database

    Dynamically scale database resources with minimal downtime

    No comments