jump to navigation

Data Migration is Evil.. 1 May 2006

Posted by deunan in Work.

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!



1. eveblackburn57897 - 8 April 2016

u00a0u9752u6625u5c0fu9e1fu4e00u53bbu4e0du56deu6765uff0cu9152u5374u662fu8d8au9648u8d8au9999u554au3002 Click https://twitter.com/moooker1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: