Doomlands of the Lunatics

Data Migration is Evil.. 1 May 2006

Well, I say that the hard part is almost done. Duplicates eliminated, hanging records purged. Now, I only need to create new 'Registration No', since the new system requires on 16 characters, instead of 25++ in the original.

What else? Oh yeah, remove all hyphens ("-") characters in the Identity Card Number column (This one needs a bit thinking). Seperate all I/C #s from old to new (This one's peanuts). Remove all instances of the apostrophe ("'" – heh!) and ampersand ("&") from Names and Addresses Fields (Ought to be fun!).  Yeah, don't forget to split the addresses field by 35 characters    (More to remind myself than just a simple blogging    )
Umm.. Hope I can finish by midnight!