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

Business Central: company data migration between different databases

(1) Share

Report

Posted on by blackone

Hi,

i have a customer with 2 different DB (BC21 version onprem); each DB contains a company (DB1 company A, DB2 Company B), and both companies are used.

These DB have the same apps (and version).

My customer asked me to migrate company B into DB1, for having only one DB with 2 companies.

I tried "ExportData" page (9901), but the file that i create is over 350MB, and i can't upload in DB1

I can't use Config.Packages because i have to move also entries.

I'm thinking to do it by SQL, but i'd like to know if there any other way.

Have you any suggestion?

Thanks

Alberto

Categories:

Dynamics 365 Business Central migration

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

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

Like (2)

Report
Copy link

Link copied!

Hi, As far as I know this is the standard method from NAV:

Exporting and Importing Companies and Other Data

https://learn.microsoft.com/en-us/previous-versions/dynamicsnav-2018-developer/Exporting-and-Importing-Companies-and-Other-Data?wt.mc_id=DX-MVP-5004336

There shouldn't be a 350mb limit on this, check your server (instance) settings.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Agree with Yun Zhu, I don't recall there being a 350mb limitation on the file

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

We don't recommend the SQL Approach, as that will cause more issues for you. Please try to use the standard functions, you can use the powershell also for exporting data

https://learn.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management/export-navdata?view=businesscentral-ps-24

Was this reply helpful? Yes No
blackone 29 on at

Like (0)

Report
Copy link

Link copied!

Thank you all.

Alberto

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central on-premises and max upload file size limit – Stefano Demiliani

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,130 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online

https://community.dynamics.com/blogs/post/?postid=41d8760c-9545-43f8-b184-152b1303ab21#:~:text=One%20of%20the%20listed%20operational,is%20by%20default%20%3D%20350%20MB.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Business Central: company data migration between different databases

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Business Central: company data migration between different databases

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the March Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates