News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Database Export

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

Suggested answer

Database Export

(0) Share

Report

Report

Posted on by john.ellis

3,494

Hi:

If you choose to export data through the Admin Center as shown below, are you exporting data for all companies?

If so, is there not a way to export data for only one company at a time?

Thanks!

John

All responses Img

All responses (3)

Answers Img

Answers (0)

YUN ZHU 85,883 Super User 2025 Season 1 on at

Like (1)

Report

RE: Database Export

As far as I know, there is no way, this feature is only for the database, not for the Company.

After exporting the data (bacpac file), you can restore it in local SQL.

When you open the table in SSMS, you will see the company name.

More details: https://yzhums.com/5010/

Hope this helps.

Thanks.

ZHU
john.ellis 3,494 on at

Like (0)

Report

RE: Database Export

Hi!

Is there not a way to export one company at a time? If not, after the export, how would someone be able to "tell" what data is represented by which company?

Thanks!

John
Suggested answer

JAngle 95 on at

Like (1)

Report

RE: Database Export

Yes, database is for all companies. BC can hold more than company in a database

Helpful resources

Quick Links

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

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans