Hi Sven > On May 15, 2019, at 5:48 AM, Sven Schwedas (sven.schwe...@tao.at) > <users@sogo.nu> wrote: > > Currently, we have a SOGo setup where each branch office has their own > server, with separate databases, and users log into their respective > branch. This obviously leads to various problems (calendar subscriptions > across branches are a pain, etc.); so we want to merge it all into one > instance. > > • Table names for each user are predictable and not randomized, so I can > take the user tables, the user's sogo_folder_info rows, and > sogo_user_profile row from the user's server and just merge them > together, correct?
Correct, as long as all c_uid are unique. > • In sogo_folder_info, I need to update the c_*location columns to have > the correct new URIs; are any other changes needed? That's it. > • In particular, where/how are subscriptions tracked and do I need to > make any changes to make them work on the new instance? Subscriptions are in the c_settings (sogo_user_profile), but don't include the full URI. So you should not have to manipulate this column unless you used "Web calendars" to view the calendars of a remote SOGo server. Francis -- users@sogo.nu https://inverse.ca/sogo/lists