Share via

Copying a Database to another logical server via the Portal

Jon Josep 20 Reputation points Microsoft Employee
2024-05-07T16:32:39.4+00:00

Copying a Database to another logical server does not show the available Elastic Pool in the destination when using the Portal. What is the reason for this?

Azure SQL Database
Accepted answer
  1. Oury Ba-MSFT 16,901 Reputation points Microsoft Employee
    2024-05-07T23:26:01.7733333+00:00

    Jon Josep Thank you for clarifying the above.

    My understanding is that you are trying to copy an elastic pool database to another logical server within the same subscription and same resource group, the Portal will not show the available Elastic Pool depending on the tier etc

    If the source Elastic Pool is Business Critical while Destination is General Purpose. This is not supported during copy.

    It will only work if the Destination is Business Critical. Same for General purpose.

    In conclusion, you can only copy individual DBs but then it needs to be within the same tier.

    After copy, you can change the service tier of the destination DB, or if you copied into a pool, then the entire pool's service tier can be changed. You can't just change an individual DB within a pool to a different service tier.

    Regards,

    Oury

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jon Josep 20 Reputation points Microsoft Employee
    2024-05-07T19:55:09.7666667+00:00

    Hi that is right. Both Source and Destination Servers are on the same Subscription and Resource Group. There are two different Elastic Pools, one on the Source and on the Destination. Source however have a higher tier than the destination Elastic Pool.

    0 comments