Small and medium business | Business Central, N...

Migrate oncloud saas to onprem with all data using export db feature from cloud

(5) Share

Report

Posted on by SP-16091559-0

🚨 Need Help: Migrating BC SaaS to OnPrem

I’m currently working on migrating a Business Central (BC) SaaS environment to an OnPrem setup, and I’m stuck at a critical step.

Here’s what I’ve done so far:

Exported the database from the BC SaaS environment.

Restored the database in my local SQL Server.

Installed the same version of Business Central OnPrem.

Connected the restored database to the BC server instance.

Issue:

When I try to start the BC instance, it fails with the error:

❌ “Metadata object not found” or “Application object not found.”

I even tried creating the missing table manually, but then it throws another error. At this point, the BC service instance is not starting at all.

👉 Has anyone faced this issue while migrating from SaaS to OnPrem?

👉 Do I need to run any additional sync or upgrade steps after restoring the SaaS DB locally?

👉 Any suggestions or best practices to get the instance running would be greatly appreciated.

Thanks in advance for your help! 🙏

Categories:

Dynamics 365 Business Central migration

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

YUN ZHU 99,261 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Microsoft doesn't support reverse migration, from SaaS to On-Premises.
Your exported database can be used in Docker, but not in On-Premises. This means it can't be used in a production environment.

More details: Dynamics 365 Business Central SaaS: How to Export Database and Restore it on Local SQL Server

https://yzhums.com/5010/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,950 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

HI

When migrating a Business Central (BC) SaaS database to an OnPrem environment, simply restoring the SaaS database backup to a local SQL Server and connecting it to the BC OnPrem instance is insufficient. The errors "Metadata object not found" or "Application object not found" arise because the restored database does not have the necessary application metadata synced or aligned with the OnPrem BC server instance. After restoring the database, it is critical to run synchronization and upgrade commands using PowerShell cmdlets like Sync-NAVApp or equivalents for BC to sync the database schema with the application objects that are installed on the OnPrem server. This ensures the application metadata and objects are properly loaded and registered, which resolves the metadata errors. Moreover, the OnPrem environment must have the exact application version and extensions installed that match the SaaS database schema; otherwise, discrepancies in metadata will cause failures on instance startup.

Additional recommended steps include mounting the restored database as a new tenant in BC OnPrem and executing any necessary database upgrade or schema synchronization steps through the BC Administration Shell. This can involve compiling all objects, repairing app extensions, and clearing any corrupted metadata records if needed. Manually creating missing tables is not advised because the root problem is the mismatch in metadata and application definitions, not missing database objects alone. Following documented upgrade paths and using supported BC tools for metadata synchronization after the SaaS database restore is required to get the BC service instance running successfully in an OnPrem setup

Thanks

Nimsara

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,950 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

https://community.dynamics.com/blogs/post/?postid=5cf0d3e2-f086-4cba-90e9-54df43cd874d

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,424 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Namaste

Microsoft has always shared information on migrating BC-OnPrem into BCE Cloud . There is no proper documentation in Microsoft Docs. Infact , Cloud always had more set of tables and has extended architecture . You need to ensure after migration data is correctly pushed .

Below is data architechture how data moves from on-prem to cloud . We need to do the reverse.

Refer these links ( Self have not tried , But you can refer)

For Backup

https://demiliani.com/2019/11/06/dynamics-365-business-central-exporting-a-database-backup-from-a-saas-tenant/

For Restoration

https://freddysblog.com/2021/03/02/restoring-your-online-business-central-database-locally/

https://blogbcrs.wordpress.com/2020/03/05/how-to-use-the-restored-business-central-saas-database-on-on-premise-environment-part-ii/

If you feel helpful , please verfiy the answer

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,759 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi,
You can export a Business Central SaaS database as a BACPAC file from the Business Central Admin Center to an Azure Storage account and then download it. This is documented on Microsoft Learn:
Exporting Databases in the Admin Center [1].

The BACPAC can be imported into SQL Server using standard SQL tools (Import Data-tier Application). This is supported for data access and analysis, not for running a production On-Prem instance..

What Microsoft Does NOT Officially Support

Reverse migration (SaaS → On-Prem) for production use is not an officially supported scenario. Microsoft only provides supported paths for On-Prem → SaaS, not the other way around.

Bottom Line

Yes, you can take a backup from SaaS and restore it locally for analysis or dev/test.

No official Microsoft support for using that database in a live On-Prem production environment.

If you attempt it, you must ensure version parity and extension sync.

Mark true, “Does this answer your question” if it helps.

Was this reply helpful? Yes No