FYI: It is NOT entirely possible to backup your companies & security is very difficult

We recently needed to move our entire program SAGE & all associated data to a new server. 

We were very surprised to find that there is no way to migrate to the new server without losing all the users and BOTH the "system level security" AND the "company level security".

Then I tried to just "restore" a company from backup to the same server. Lost the company level security.  So, when you "backup company"; you are backing up the data & the reports & the profiles; but that's it.

So, what does that mean to us?  We have to go into each & every company that we have 1 by1 ....all 600 of them.  Open the company and add all 14 users to one of the 3 company security groups.  It will take many many man hours to do this & is wrought with potential for error.  The company profiles come over; but not the company privileges.  And there's no way to assign the same company privileges to a group of selected companies all at once. 

It's crazy....

  • 0

    ..AND everytime a user joins the department or leaves the department we have to go into each & every company 1 by 1....all 600 of them & add or remove that person.

  • 0

    Hello TinaLouise,

    I had to do some checking, and I found that we do have a custom app for assigning profiles to companies and users without having to open each company through our Professional Services Group.

    This is not a free utility and I have not actually seen it but my sources tell me that it will allow the editing of the Password Security across all the companies in a database. 

    To contact the Professional Services Group (PSG) please contact your account manager at 800-368-2405.