1. Home
  2. Point-Of-Sale Software
  3. Copy security Settings for RMS Store Ops 2.0 to other stores:

Copy security Settings for RMS Store Ops 2.0 to other stores:

Copy security Settings for RMS Store Ops 2.0 to other stores:

I have 7 stores using RMS Store Ops 2.0, and HQ. I want to make a master setting at one location and copy it to other locations, what?s the best way to copy security settings from one location to other location.

Reply to
Jimmy
Loading thread data ...

Hi Jimmy,

Try this:

1º set up a model RMS SO database, based on your stores and apply the Security Configuration yuou wish to have. 2º Connect to the database, with RMS SO Administrator and exec this query: "SELECT 'INSERT INTO [Security] ([FormName],[ClassName],[ControlType],[ControlName],[ControlIndex], [ReadDisableCode],[ChangeDisableCode],[ColumnTitle]) values ('+''''+FormName+''''+','+''''+ClassName+''''+','+''''+ControlType+''''+',' +''''+ControlName+''''+','+''''+rtrim(cast(ControlIndex as char))+''''+',' +''''+rtrim(cast(ReadDisableCode as char))+''''+','+''''+rtrim(cast(ChangeDisableCode as char)) +''''+','+''''+ColumnTitle+''''+')' FROM Security" (this will give You all the INSERT's that You will need for the rest of the stores) 3º Go back to your RMS HQ Manager, and after doing all the Backup's needed, for all the RMS databases HQ and the stores, create a new Worksheet, type 51, containing all the INSERT's (results from 2º) into the Worksheet lines Please remeber that, Worksheet 51 has a limitation of string lenght (think 256 char) per line, so You may need to make few Worksheets or more lines in the same worksheet.

Please make backups on all the databases before You try this.

Best regards, A.

Reply to
Antonijo Todoro

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.