Are we able to use Azure SQL Always on Availability groups to manage the replication between two Azure SQL Managed Instances (one and two) so that one of our databases is "primary" or read/writable on Azure SQL Managed Instance two with a read-only replica on Azure SQL Managed Instance one? With all other databases as "primary" or read/writable on Azure SQL Managed Instance one with their read-only replica on Azure SQL Managed Instance two.
We have a legacy setup with a reporting database on a transactional server. This transactional server is hosted as an Azure SQL Managed Instance replicated to a secondary instance. There are stored procedure ties between our transactional databases and reporting database which makes moving the reporting database to another server difficult. We'd like to use the two instances we have to move the processing load of the reporting database but still leave a read-only replica of the reporting database on the primary transactional instance.