Hi Sven
> On May 15, 2019, at 5:48 AM, Sven Schwedas (sven.schwe...@tao.at)
> 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
