Switching Between Databases

I don't think so. If you find a way, please post it here.

Tom

You can do this by exporting the registry settings for each database setup (HKLM\Microsoft\Retail Management\Store Ops\Server\Database) and then use regedit to imports the registry file each time you want to switch.

1 . While system is set up Store A

1. Open regedit got the key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database] right click and export to desktop as Store A
2. Start up Store Administration and change the settings to Store B, Open regedit goto the key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database] right click and export to your desktop as Store B.

To change between the stores double click the Store A or Store B reg file and answer yes to the prompt, this is the same as importing to the registry.

Regards Michael Esposito

Hi ... actually you can make windows .bat file which will ask you to which database you want to switch and then import registry value depending on your answer. anywan yao can use a bat file for each of your stores, hat will inport registry value and then open application ... you will just do a few clicks less :()

I have a laptop that I am planning on taking with me to sell Membership cards at meetings for the intended audience. I have populated a database with backup information from the POS. My question is, How do I import only the customer information that I change on the laptop without importing all of the data(items, etc). I am afraid that when I import the info from the laptop to the POS, I will lose all the things that went on in the POS prior to backing up with the info from the laptop. Thanks

Hi there ... here is some example that will work on windows xp , if your version is different just let me know ok ? Put this text in a text file on your desktop, then change extention to .bat like you will have something like "switch.bat" This will do all the job you need, just run it and follow instructions

--start --

@echo off set server_1_reg_file="C:\Program Files\Microsoft Retail Management System\Store Operations\server1.reg" set server_2_reg_file="C:\Program Files\Microsoft Retail Management System\Store Operations\server2.reg" echo Hi Manager !!! echo. :server1 if exist %server_1_reg_file% goto server2 echo Please enter #1 server information in OPOS Administration Utility and Save echo Press Any Kay When Done pause regedit.exe /e %server_1_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:server2 if exist %server_2_reg_file% goto filesexist echo Please enter #2 server information in OPOS Administration Utility and Save echo Press Any Kay When Done pause regedit.exe /e %server_2_reg_file% "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Server\Database\"

:filesexist

echo Please select into which server you'd like to log in. echo. echo Enter "1" For Server 1. echo. echo Enter "2" For Server 2. echo. SET /P server_var="Set Server To #: " if %server_var% EQU 1 ( regedit /s %server_1_reg_file% goto startpos ) if %server_var% EQU 2 ( regedit /s %server_2_reg_file% goto startpos ) echo Please enter 1 or 2 echo. goto filesexist :startpos call "C:\Program Files\Microsoft Retail Management System\Store Operations\SOMANAGER.exe"

--end --

Be cautious using this method to switch databases if you also have an offline DB configured. If you switch the live DB you must also switch the offline DB. Otherwise the offline DB will be damaged when you close a batch and the synchronization process runs.

The offline DB info is stored in the registry, so you could extend Ashot's method to switch it at the same time.

Ken Kosnik

I understand the concept here, but for some reason it is not working for me.

I used SO Admin to change the settings for all 4 of my stores. After I set up each store I exported the .reg file to my desktop. Then I opened SO Manager to make sure i was connected the the right store.

However, when I go back to test each .reg file, I double click it and save it to the registry, but when I open SO Manager, all 4 .reg files result in a connection to the same store!

All .reg files have different Data Source keys, but when I save the .reg to the registry, it says successful, but the Data Source key does not actually get updated in the registry for some reason...

Any ideas?

1) Are you logged in to Windows as an Administrator? Limited users do not have permission to modify the registry by default.

2) After exporting the .reg files, make sure you open them in Notepad and save ( I always turn Word Wrap On then Off first ). The files export with some weird word wrapping that prevents some of the keys from being properly updated until you correct it.

Glenn Adams Tiber Creek C> I understand the concept here, but for some reason it is not working for me. >