5
We have three distinct stores with distinct inventory. Is there a way to maintain different databases and still be able to use one computer running Retail Operations Manager and access them all? Right now we have to go to different computers which are dedicated to each store.
Thanks for any insight you can give!!
*This post is locked for comments
OK, I found the files.
Basically the solution is in two different .Bat files that is executed by the user, instead of running the shortcut of the RMS SO Admin to change the database and then running the RMS SO Manager. Each .BAT file is for a different RMS database. All the .REG and .BAT files have to be in the same folder.
Inside the .BAT file, before executing the RMS SO exe file, the .BAT file is executing a .Reg file that is changing the database name where RMS is pointing, so the "correct" database.
Here is the code:
1º) The .REG file code is something like
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Headquarters\Server\Database] "Initial Catalog"="RMSHQDatabase1"
2º) The .BAT file code should be something like this next:
"@echo off
cd\
start /wait SP.reg
cd "C:\\Archivos de programa\\Microsoft Retail Management System\\Headquarters\\"
start HQMANAGER.exe
@echo on"
where SP.reg is the name of the .REG file. You will need to edit a little bit the .REG and .BAT files to adapt it to your needs.
If you need help, do not hesitate to contact me directly.
Please verify my answer if this solution works for You.
Best regards, A.
Actually, it was a combination of 2 .BAT's and 2 .reg files, I'm trying to find them, will ge back to You.
BR, A.
Hi, Antonijo please forgive me for ask do you have the sample of the .bat file?
wow. this is fantastic. do you have the .bat file or a sample of the .bat file?
No way. but you can use a department, category, bin location to separate inventory and filter reports. Even if you have same item in different location, you can use the MultiLocation inventory add on. contact sales@solucionessimples.net we can help you.
Hi there.
Apart from the quality answers You are already getting, I wanted to add an idea for you to consider, something I did for a Customer in Spain, that had 2 different RMS HQ databases (2 different stores chains) and wanted to access the information from a single PC simultaniously, with one RMS HQ installation. This is simular to what you want to do I beleive, access 3 different RMS Store Ops databases from one RMS SO installation from one single PC.
OK, what I did was delete the RMS HQ Manager shortcut icons from the desktop. I've created 2 different BAT files, with simple code inside that was "changing" the database (basically deleting the registry entries with the database info, where RMS was "pointing to", and running the RMS HQ Manager (RMS SO Manager in your case) just after the change. This way, the final user was clicking only on the BAT file he wanted to run and the "correct" database was opened.
OK, this "solution" is simple enough, I think. You may have to play arround to make it work, but it's not too hard.
Hope this helps. Write me if You need more help.
Kind regards, A.
If you have back office computers at each location you can also setup LogMeIn / Teamviewer and then just have 3 sessions running at once and switch between them.
Another easy work around is to make sure your SQL server at each store is accessible over the internet (or put all stores and your main machine on a vpn). On your main office computer install RMS Manager. to switch between them, simply go into the RMS Administrator and change to the IP & database for the store you want to connect to. If you have a decent internet connection and don't do anything too intensive that should work fine for you.
The simplest solution would be to run three virtual machines on your PC. Install and configure the RMS Manager program on each and then just switch between the virtual machines as needed. Since Manager has no licensing requirements that should even be within your licensing agreements.
If you want to try to get fancier, from my understanding, RMS uses registry entries at startup to determine which database should be opened and where various files are located. Win7 has a feature called Application Virtualization. Normally that is used to redirect registry accesses that force the application to run as an administrator to an alternate place in the registry where administrator permission is not required for updates. It can also redirect file references to a different place in the file system.
The Microsoft ACT (Application Compatibility Toolkit) can be downloaded from Microsoft's website. It allows you to make up profiles (they call them databases) for different applications that can be used to re-direct an application's access to system resources (i.e. registry keys and file paths) to different places. I think that if you do it carefully, you could install three independent versions of SO-Manager using separate registry trees and separate places in the file system that would allow you to have three versions of SO-Manager installed which could each be separately configured.
Between the CorrectFilePaths, RegistryReflector and VirtualRegistry shims in ACT, you should be able to virtualize SO-Manager to allow for three fully configured installations that are independent of each other. This is not for the faint hearted if you have never played with application virtualization before, but would be a slick solution for what I think you are looking for.
I am about 95% sure it could be made to work. I am 100% sure that would not be a supported configuration by Microsoft, so you'd be on your own if there were issues. Since Microsoft says you can run as many copies of SO-Manager on as many PC's as you'd like, I would think that both of my virtualization ideas would fit within the licensing for RMS.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (