HQ - can it support 2 db's??

Question

Currently we have an RMS implementation, which consists of an HQ and seven remote stores connected to it. I would like to know if it is possible to connect another database to RMS HQ. By this, I do not mean another remote store, but a new database for a store that has nothing to do with the other seven. I need another database because the new stores? data is not to be ?seen? by the other remote stores? users. To connect RMS HQ to this new database we can use different login credentials. Obviously all rms software used is same version, 2.0.

Thanks, Nick

Glenn Adams · Accepted Answer

Couple of issues...1) I believe that you would be violating the license agreement by operating 2 distinct organizations on the same HQ License.2) Why bother with HQ for a single store?  If you are later going to have multiple stores in the different line of business, it may make sense.3) You need a separate instance of HQ Server for the second DB, not just HQ Manager.  MS does not recommend multiple instances of HQ Server on the same server, even though it IS possible to set it up that way; so, this implies extra hardware.So, what you are asking is technically feasible, but violates the license.  Maybe there are other solutions that would meet your needs.  If nothing else, buying a second HQ license would resolve that part of it.  Maybe if you add some explaination on why you are considering this someone will have some alternative ideas...

Nick · Answer

ok, so basically 1 company has 7 outlets for a particular line of shops, and they opened a new shop on a different sector of the market. 7 outlets being toyshops and the other one is an auditorum with souvenior shop and coffee shop. both are distinct business but they still are of the same owner/company. the idea was that both businesses are available at the head quarters office but the managers at each business could not access data about the others.  "Glenn Adams" wrote:

convoluted · Answer

The individual stores will not see each other's sales - only HQ will see sales for all locations - also, do not enable the "check stores" feature (HQ Client tab in SO Administrator) which allows locations to check stock status of other locations - You could also make toy items "inactive" at the coffee shop so they are not viewable at the coffee shop.  I think these considerations should address your concerns, pls advise if they don't - "Nick" wrote:

Nick · Answer

ok thanks for your answer. another question...how do you make these item inactive? thanks"c

convoluted · Answer

In Store Ops Manager, go to wizards - run task 210 make items inactive - select items to update using one of the options (ie, items in this department, in this category, from this supplier, etc)  - -- if you make an item inactive by mistake, run task 200 make items active, to make it "active" again....Another option is to manage item creation and propagation in headquarters - when you create toy items, use worksheet 250 to send the toy items to all stores EXCEPT the coffee shop; that way the items will not be in the coffee shop database - hope this helps."Nick" wrote:

Nick · Answer

Thanks, will try it out and let u know what happened"c

HQ - can it support 2 db's??

Join the Discussion

Didn't find your answer?