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 95,329 Super User 2025 Season 2 on at

Like (2)

Report

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 31,340 Super User 2025 Season 2 on at

Like (2)

Report

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,243 Super User 2025 Season 2 on at

Like (2)

Report

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

Thank you all.

Alberto

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

Like (1)

Report

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. 20,275 Super User 2025 Season 2 on at

Like (1)

Report

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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates