Migrate from Azure SQL to Azure SQL hyper scale

Verma, Manish Kumar 131 Reputation points
2020-08-27T07:15:07.767+00:00

hi all,
i have azure SQL server with two db 4 TB each. now we have limitation of 4TB for a single database.

to overcome this issue are planning to move Azure SQL hyper scale with 100 TB.

our question do we have 100 % compatibility for Azure SQL to Azure SQL hyper scale.

please suggest , what is the best way to handle this

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ronen Ariely 15,191 Reputation points
    2020-08-27T07:31:02.42+00:00

    Good day,

    our question do we have 100 % compatibility for Azure SQL to Azure SQL hyper scale.

    everything you do is on your own responsibility, and I will not advice you what to do in the scope of the forum, but according to what I know the answer is yes.

    it is well documented in this document:

    https://video2.skills-academy.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq#can-i-move-my-existing-databases-in-azure-sql-database-to-the-hyperscale-service-tier

    Notice the recommendation NOT to move the production database but instead to CREATE COPY of the database

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.