Migrating between different databases (Or simply changing the database your data is on) E.g. DTU Basic to VCore Business Critical (As an example)

Debbie Edwards 341 Reputation points
2020-09-16T11:04:22.25+00:00

Hi all

I am working with people that are used to working on premises. they are used to doing a lot of work when migrating to new SQL Servers.

I was wondering, in Azure if you started on say a small DTU single database and decided to change the database.

I'm thinking any example really, from say the DTU to Vcore Business Critical, or a single DTU database to an elastic pool database

Whats the process for this kind of move? Would they have to do exactly the same lift and shift procedures as before on premesis or is it really easy to change the type of database you are on?

Thanks in advance

Debbie

Azure SQL Database
No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,261 Reputation points
    2020-09-16T11:55:19.923+00:00

    Hi anonymous user, Welcome to Microsoft QnA forum. If I understand your query correctly, you want to know how to switch the database from one tier to other e.g. from DTUs to VCores. Also you want to know the process to migrate from single Database to Elastic pool. Please refer to below details:

    1) Migrating from DTU to VCores: Go to Pricing tier as highlighted in the screenshot, then change the tier and click on 'Apply' button, it should be done within minutes. You can move from VCores to DTUs same way.
    a)
    25038-image.png

    b)
    24990-image.png

    2) Migrating from Single Database to Elastic Pool(Assuming both have same server):
    a) Go to SQL Elastic Pool
    b) Select Configure under Settings from left menu
    c) You will see 3 tabs, Pool Settings, Databases and Per Database Settings. Select Databases
    d) Click on Add Databases, you will see the list of databases available, pick and select whichever database is needed and click on Apply as below. Then click on Save button. This will add database to elastic pool within sometime.
    25224-image.png

    Please let us know if this answers your query.


    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    No comments

1 additional answer

Sort by: Most helpful
  1. Debbie Edwards 341 Reputation points
    2020-09-17T13:50:08.573+00:00

    thank you. Seems very straight forward

    No comments