[horde] Fwd: Need help to merge 4 seperate horde installs

[Daniel A. Ramaley]

If i had to do this, first i'd verify that all 4 servers are running the 
same versions of the same Horde components. Then i'd decide which of 
the 4 installations will be preserved (the master). Make backups of the 
database on that machine, and test that the backups can be reloaded. 
Then pick one of the other machines to be merged with the master and 
dump its database tables. Examine the dump file and make sure tables 
will not be dropped when it is reloaded, then try loading it on the 
master. Shut down the machine whose database was copied over, and tell 
people who formerly used it to use the master machine instead.

I don't know if this will work or not, but it is how i would start 
thinking about the problem. One obvious limitation is that if people 
have preferences on multiple Horde installations, only 1 set of 
preferences will survive. If there are not many such people, it may be 
easiest just to tell them that they might lose some data, and if they 
are concerned about address books or other really important data that 
they export a copy for themselves and import it after the migration. 
But if most of the users have used more than one Horde server, then 
you'll need to come up with a more elaborate plan to merge the 
databases. Whatever you do, make sure you have verified backups before 
beginning.

Someone with more knowledge of Horde internals, feel free to tell me how 
my plan would blow up and cause data loss.

On Tuesday 21 November 2006 05:41, netty 2006 wrote:
>Hello,
>
>Can anyone help me with this?
>
>Regards,
>Netty
>
>---------- Forwarded message ----------
>From: netty 2006 <netty2006 at gmail.com>
>Date: Nov 19, 2006 7:03 PM
>Subject: Need help to merge 4 seperate horde installs
>To: horde at lists.horde.org
>
>
>Hello,
>
>We have 4 seperate horde 3.1.1 installs on seperate servers.
>Now we wish to run a seperate horde server that serve users of all 4
> installs. Here i need help on merging user preferences, address
> books, memos, etc for all 4 installs into one.
>
>I tried to lookup but couldnt find an adequate anwer anywhere.
>Can someone guide me how should i go for this merge?
>
>Another problem i have is duplicates in a few installs.
>Like someuser at domain.com may exist in 2 installs, so it may create an
>issue in merging them.
>
>As i see there isnt a straight way, but even if someone can guide, it
>will help a lot.
>Even if it needs scripting or data transformation of some sort.
>
>Regards,
>Netty

-- 
------------------------------------------------------------------------
Dan Ramaley                            Dial Center 118, Drake University
Network Programmer/Analyst             2407 Carpenter Ave
+1 515 271-4540                        Des Moines IA 50311 USA