We have a Azure SQL Database with one read-only replica. We want to upgrade it to a plan that makes the replica active, so that it becomes readable.
However, the upgrade procedure produces the following error:
Database scale operation from S1 Standard to P1 Premium failed for theDb. ErrorCode: undefined ErrorMessage: The operation cannot be performed since the database 'theDb' is in a replication relationship.
Which is understandable. But I am not sure in which order to du stuff without loosing data or having to restore everything from scratch.
In which order am I supposed to do stuff here?