I need to copy a Hyperscale DB to another server in the same region/location, (the copy function is in coming soon state but not already available) does someone know how?
Copy Azure Hyperscale DB
azure-sql-database
Related Question
- Sql-server – What are options for Bi-Directional Replication of SQL Azure Database
- Azure SQL Database – How to Restore After Server Failure
- Azure SQL Database Error 18456 – Severity 14, State 1
- Azure SQL Hyperscale – How to Copy Databases
- Azure SQL Database – Copy Encrypted Database Between Subscriptions
- Azure SQL Hyperscale, Very Large Tables, and lack of explicit partitioning
Best Answer
Database copy for Hyperscale is now in Public Preview as announced here on Sep 22, 2020.
If you don't like the current functionality, another option is creating a new database by restoring an existing backup.
When a copy is needed to another region use a geo-restore of the database. Create a SQL Database server in the target region if you do not already have an appropriate server there. This server should be owned by the same subscription as the original (source) server. Finally perform steps provided here.