We are looking to upgrade a handful of existing PowerApps single-tenant applications, which are part of an overall application suite, that use SharePoint Lists for storage to a multi-tenant architecture with a CDS back end and one database-per tenant, which of course may be an elastic pool for cost-effectiveness. We would first like to understand if it is possible to have the same schema in CDS as we do in our SharePoint Lists so that there is little-to-no modification to the apps required to change out the back end to CDS. If this is possible, we would like to understand what tools are available for our centralized system administrators to manage the multiple single-tenant databases on behalf of our customer network. We also need to understand how to estimate the price of this solution as we will need to budget this for a few different usage levels based the size of our customer network.
Does anyone have experience with this or know of someone at Microsoft that could assist with this?
