Converting Your SQL Server Database to MySQL

I’ve been trying to convert a SQL Server 2000 database to MySQL, because I’ve grown to like MySQL, and find it easier to manage (using Navicat).

After trying DTS, Navicat’s import features, and a slew of conversion products, I’ve settled on a product I stumbled upon last night.

http://dbconvert.com/

I must say, this is one of the slickest programs I’ve ever used. It just flat-out works.

A problem you’ll find with some of these converters is, they will not define your foreign keys. Ugh! I don’t wanna have to manually define those again! I have 75 tables in this database. DBConvert to the rescue. It seems to define my PK’s, FK’s, and indexes properly – Nice!

It even displays errors and potential problems with your table objects.

The only problem I’ve had is the data itself. DBConvert seems to get “bogged down” when it’s trying to insert a lot of data into my tables. I’m having to manually convert the data using the program’s filter options. It definitely goes a lot faster.I’m simply copying over the data, and unchecking the “copy structure” checkbox. Then you click the Filter button, and manually define what you want. It’s pretty easy.

Adding the data

Enjoy!