[Gllug] Data migration and electronic archaeology

[Jackson, Harry]

> -----Original Message-----
> From: John Hearns [mailto:john.hearns at cern.ch]
> 
> Or more about transferring data between databases -
> how easy is that in the Real World, and how often is it actually done?

Migrating identical schemas together for 13 countries, fscking nightmare.
Checking user data anomalies between schemas, fscking nightmare.
Checking reference data between schemas, fscking nightmare.
Checking business process usage between countries, oh fsck.
etc fsck.
etc fscking hell.

These are relatively modern systems so I dread to think what it would be
like if you needed to recreate the schema with all the relative business
rules in place before migration.

All in all its a fscking nightmare but I am enjoying the experience.   

H


*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or 
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message.  Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************



-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug