Microsoft Dynamics 365 Business Central development team never officially tested creating an on-premise (Docker contained, virtualized or physical) environment around a restored SaaS backup.
For this reason, Microsoft does not provide any support in creating a multitenant or single tenant on-premise environment built upon a restored SaaS bacpac.
This is clearly and officially written in the Microsoft documentation:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/tenant-admin-center-database-export
Important
While you can import the downloaded .bacpac file into your own SQL Server instance, Microsoft does not provide support for creating a working on-premises environment from the .bacpac that you download from Business Central online.
The rationale that lies beneath the missed supportability scenario are mainly due to:
- The very same exact Application version might not be downloaded officially due to the out of band hotfixes (application and platform) that could be part of SaaS.
- It is not possible to deploy 3rd Party AppSource apps (unless the exact same version and number are provided by the 3rd party).
- You might not have exactly the very same Per Tenant Extension (PTE) that needs to be deployed in advance within the application database
- There might be differences in database collation, if you intend to merge application and tenant database
- SaaS is working with entitlements within the license while On-Premise this concept does not exists and permissions rely only with on-premise license permissions. This might lead to different application behavior.
And several others.
Microsoft Dynamics 365 Business Central development team does not have intended restoring a bacpac file as a viable official solution to move back a customer tenant from SaaS to On-Premise but only to double check and review table contents and / or perform statistic and analysis offline within the restored database.
Therefore, if you would like to try to create a multitenant or single tenant (legacy) environment around a restored SaaS bacpac, you might investigate your own the best way to achieve this by having well tattooed in mind all its limitations and constraints.
As per best effort, you might get inspired by the following links:
(based on 15.2)
https://robertostefanettinavblog.com/2020/03/05/how-to-use-the-restored-business-central-saas-database-on-on-premise-environment-part-ii/
(based on 15.0)
https://freddysblog.com/2019/11/12/mounting-a-database-backup-from-my-online-environment-inside-a-container/
