1

I have a database named myAppDB on an Azure hosted SQL Server in the Eastern US Datacenter. I created a new SQL Server in the South Central US datacenter. I then Created a Geo Replica of myAppDB on the server in Eastern US to the server in South Central US. It worked! I have validated that the new database is in fact read only from SSMS and that data is being pumped across as the primary database is updated with ongoing transactions.

The problem is, that the Azure interface to create the replica does not allow the specification of the database name for the replica.

enter image description here

So now I have two different databases on two different servers, both with the same name - myAppDB. Physically this works, but in terms of usability, if I'm working in SSMS with two database server connections, it's confusing because regardless of which database I'm accessing, SSMS reports myAppDB. I'd much rather have the replica named something like myAppDB_Read just to bring a bit more clarity to my working environment. Is there any way to achieve this? (I've already tried the standard method for renaming a DB but I got an error message stating that the operation can't be performed because the database is in a replication relationship.)

Thanks for your advice!

3
  • 1
    Is Data Sync for Azure an option for you? learn.microsoft.com/en-us/azure/azure-sql/database/… Commented Apr 12 at 9:26
  • The literature at that page states that Data Sync is not the preferred solution for my use case. Data Sync isn't the preferred solution for the following scenarios: Read Scale; Use read-only replicas to load balance read-only query workloads Commented Apr 12 at 13:29
  • 1
    So I believe there is no solution Commented Apr 12 at 13:47

1 Answer 1

2

In Azure SQL Database, when geo-replication is enabled, the replica databases cannot be renamed. And you cannot define a different name for the replica database during setup also.

This has been confirmed by a Microsoft employee on StackOverflow. See here. He is motivating users who want this feature available to vote for it on a feedback site for Azure.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.