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

[Bill Graham]

Another point -
If you have duplicate names across the servers -
rectify these name copnflicts before trying to merge anything.

Bill

-- 
Bill Graham
Systems Administrator
Hurley Public Schools
Hurley,SD 57036
USA
http://www.hurleybulldogs.com
grahamcw at hurleybulldogs.com



Quoting "Daniel A. Ramaley" <daniel.ramaley at DRAKE.EDU>:

> 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
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



----------------------------------------------------------------
This electronic  mail sent from Hurley Public Schools - Hurley, South Dakota
http://www.hurleybulldogs.com

NOTICE: This E-mail (including attachments) is covered by the Electronic
Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may
be legally privileged. If you are not the intended recipient, you are hereby
notified that any retention, dissemination, distribution, or copying of this
communication is strictly prohibited. Please reply to the sender that you
have received the message in error, then delete it. Thank you.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1375 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/horde/attachments/20061121/8ce98c54/attachment.bin