Data Slinging
In order to move my blog posts from Community Server to Wordpress, I needed to move content from a Sql Server database to MySql. I hadn’t dealt with MySql for nearly a year at this point, so I went about checking out my options as far as slinging data between these different databases.
I came across this (new?) tool from MySql called the MySql Migration Toolkit. The toolkit is supposed to allow you to connect to various other databases and move your data into a specified MySql database, as of right now it supports Sql Server, Access, and Oracle.
The interface for the toolkit is very nice, along the lines of the MySql Query Browser and the MySql Administrator. MySql has really impressed me with how nice their tools have come to look, and the ease of use and installation is second to none. However, I found the toolkit to be a little rough around the edges. It took me about a dozen tries until I could finally move my data the way I wanted to, and I couldn’t get it to connect to Sql 2005 at all, I had to move the data to Access before I could get to it. The real thing that was annoying though, was that it didn’t move the content of my blog posts over correctly, which is admittedly, an easy thing to screw up.
I ended up putting my posts and comments into a CSV file and then importing them using SUS (straight-up-sql), via phpAdmin. It was actually rather easy that way, and ironically, that was the method I was trying to avoid by getting the migration toolkit. Sometimes the old school way of doing things can be the easiest I guess.
