Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Multiple companies/dat...

Multiple companies/databases/SQL 2012: All on one instance/separate instances

(0) Share

Report

Posted on by Community Member

Complete newbie with respect to SL (working with 2015), inheriting an install.

Have a situation where a group of companies (5 operating units with their own databases) installed on SQL Server in the same instance.

(each operating company is in different jurisdiction/country,, hence different accounting rules/time frames, tax regimes etc), but my understanding is that consolidated reporting is critical.

What are best practices in regards to this: All on the same instance, or create a separate SQL instance for each db/company.

What are the pro and cons of these 2 approaches ?

Is there any references/links to official Microsoft best practices/write ups that you can share; so far, has not had much luck finding same. ?

with best regards

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Bill Degnan 660 on at

Like (0)

Report

RE: Multiple companies/databases/SQL 2012: All on one instance/separate instances

You will most likely use Management Reporter to do the Consolidated Reporting.

You would use the Financial Statement translation module to translate the different operating units to a common currency then use Management Reporter to build the financial reports.

Management Reporter will require all the SL databases to be in the same SQL instance so that eliminates the option of multiple SQL instances.

The client will mostly need another SL company setup to record intercompany eliminations.