Looking to upgrade to BC Cloud.
From my reading BC 24 will automatically support a read-only replica database where all data queries will be pointed to.
I can't seem to find documentation on how MS sets up the back end databases for both production and the replica.
From my understanding what will happen is MS will create 2 Azure SQL databases, one for production and one for the replica.
All users will interface with production, while PBI will connect to the replica database.
Questions now are:
1. Will we be able to see the 2 SQL databases in Azure?
2. How often is the refresh/ update of the replica DB? Different vendors say different things on how often it is refreshed. No clear answer from whom we've discussed with. We want a near real-time update of PBI in BC and sharepoint for dashboards, and score cards,
3. Are we going to utilize for double the storage for the data now compared to how old/ on-prem BC works?
Please site the sources if you have them. MS and chat gpt not helpful with the sources.
