One of the most mundane things I've been working on for the new CoasterBuzz is the data migration. It's boring work. There are a lot of changes in the way data is stored.
The forum data is a solved problem, as I had to do that for PointBuzz. It's nearly all straight SQL, selecting from the old and inserting in the new. The coaster and park databases are a little more challenging. The news is an outright pain in the ass, because it uses the forum to drive the comments instead of it being a stand alone thing the way it is now. I haven't done a dry run yet to see how long it would take, but I'm guessing it'll take an hour in real life to migrate it all.
Last night I wrapped up the work on the news migration, and ended up going to bed around 2:30 in the process. The problem is that when you run the conversion, and you want to delete the data from your last test run, even the delete part takes five minutes. I've not bothered to make a little subset of data for testing.
So I'm headed into the last 10% of work, which I suspect will take the longest. But there is an end in sight.
No comments yet.