web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Convert HQ database to...
Microsoft Dynamics RMS (Archived)

Convert HQ database to a single store

(0) ShareShare
ReportReport
Posted on by Community Member

I have a client who has a multi-store set up in HQ, but he will be closing all stores except one, and would like to change the HQ database to a single store RMS database.  Is there an export/import procedure for that?

 

Thanks,

Mathew

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Convert HQ database to a single store

    If they want to stop using HQ and operate only one store....

    - Uninstall the HQ Client application at the store

    - Reset the security settings so that at least one security level can create data previously managed by HQ (items, departments, suppliers, tenders, etc.)

    - There is a KB in Partnersource that explains how to reset the storeID; I don't think it's necessary, to reset it back to zero, but it would put the SO database back to its original state (single store operations db has a storeid of zero).

  • Community Member Profile Picture
    Community Member on at
    RE: Convert HQ database to a single store

    They want to stop using HQ and operate only one store.

    Thanks,

    Mathew

  • Community Member Profile Picture
    Community Member on at
    RE: Convert HQ database to a single store

    Can you clarify

    - do they want to keep HQ and just operate one store

    - or do they want to stop using HQ and just operate one store

    If they want to keep HQ and just one store - say,HQ is in Dallas, the store is in NY - do they want to remove all closed store information from the HQ database?

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,743 on at
    RE: Convert HQ database to a single store

    If you prefer to use HQ, i dont think export and import will do. Backup you database and call a database expert to manually delete all data pertaining to the stores which will be closed.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans