News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Companies in Separate ...

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

Answered

Companies in Separate Databases

(0) Share

Report

Report

Posted on by JE-29041340-0

378

Hi:

Why do some companies reside in separate databases, instead of the same database?

Is it best to place a company in a separate database, if that company is different from the other companies due to differences in currency, fiscal year structure, and chart of accounts structure?

Thanks!

John

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (1)

Report

Companies in Separate Databases

There can be several reasons why you want to separate companies into different databases if you are running Business Central on-prem.

The most common reason is if you have companies that will not run on the same code bases or need different customizations.

Another reason can be the size of a company. If you have a very large company then you might want to split them into different databases.

If you run different local currencies in companies they will probably need different localizations and they you will have to run them in different databases.

Chart of accounts, fiscal years and stuff like that is just data so those aspects does not require separate databases.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2

Martin Dráb 230,569 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans