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

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Multiple HQ Databases to Master HQ Database?

(0) ShareShare
ReportReport
Posted on by

Does anyone using setting multiple HQ Databases with Master HQ Database?
I am wondering, what if I have more than 100 stores, how do I maintain all SO stores with a single HQ Database?

Do I need to move on to another system?

*This post is locked for comments

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

    Standard RMS not support Master HQ Database. I think this application was announced by one partner since 5 years ago. but you can consolidate multiple HQ in Reporting using SSRS or QRP Reports.

    RMS can support more than 100 stores but  if you need a fully integrated back office you must take a look on AX 2012 R3 For Retail.

  • Verified answer
    Community Member Profile Picture
    on at

    Hello Dr. Ryu,

    Thank you for your question.

    RMS is not designed to use multiple Headquarters databases reporting to a singular, master Headquarters database.

    The previous response recommended a third party application that may assist you with your store management.

    Thank you,

    Scott Wardzinski

    Microsoft Dynamics RMS & POS Support Engineer

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans