web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Management Reporter DB...
Microsoft Dynamics SL (Archived)

Management Reporter DB question

(0) ShareShare
ReportReport
Posted on by Community Member

Client wants to do their own MR install, and after reading thru the install guides, they have the following questions:

The documentation states that the setup user needs sysadmin permissions and permissions to create a database.  Does this new application have its owns database or does it snap into an existing database? 

If this creates a new database what is the name of the new database and what is the estimated size and growth of the new database?

Thanks,

John

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Answering my own question - Here's some info I got from a colleague:

    MR creates its own SQL database.  MR doesn’t create any objects in SL Databases.  Default MR database name is ManagementReporter, but this name can be changed during installation process.

    This application is so new that we don’t have any data on DB size and growth.  It will only contain MR Companies and report templates, just as FRx does.  I wouldn’t expect this DB to ever grow over 1 GB.

  • Suggested answer
    rudra Profile Picture
    rudra 6,534 on at

    Hi ,

    We could not predict the Database size as 1 Gb because once the initial integration completed then the periodic integration will begin so whenever the reports definitions modified in the SL database accordingly it will increase the space in the MR Datamart database as well.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans