HI,
I have a Azure SQL serverless with four databases in Production environment. Here, Customer asks us to copy all databases from Production to Preproduction environment. Production environment in North Central US whereas Preproduction in South Central US. How to copy all databases from Prod to Preprod ? Is there any way to take snapshot and copy to Preprod SQL server? In AWS, we have option to take snapshot and copy to any other region then make this snapshot as RDS instance. Same can we have any option in Azure SQL Serverless? Kindly advice on this.


HI