jfw.id.au

Here it is, a little after 11PM on a Saturday night and I am busy trying to migrate data between old and new systems. We have been working on a major rewrite of the core systems for work and we’re up to the data migration and rollout phase.

I’ve been responsible for a fair amout of the data migration routines, and I am currently attempting to migrate all the booking information. I made an adjustment to the stored proc for this routine and neglected to update the code that calls it. This lead to none of the bookings that I was attempting to migrate actually making it accross.

My tiredness and lack of caffeinated beverages caused me to forget that the stored proc had been updated and spend the better part of an hour looking at a selection of the bookings trying to work out what had caused them not to migrate. I did not realise that none had made it across.

I eventually worked it out, and feel stupider for the experience.