Menu

Almost useful

As of today, the script is successfully reading from the INFORMATION_SCHEMA tables of a SQL Server database and writing out almost usable MySQL CREATE TABLE statements. What it lacks to be useful are the sizes on the datatypes. For example, a typical converted table looks like this right now:

create table Zip {
Zip char NOT NULL ,
City varchar NOT NULL ,
State char NOT NULL ,
Lat decimal NOT NULL ,
Lng decimal NOT NULL ,
County varchar NOT NULL
};

You can't use that yet. But I'm pretty excited that it is working this far in just two days! I can only work on this as time permits, but I think this will be a genuinely useful tool in just a few weeks.

I'll keep you posted!

Posted by Michael Schwarz 2008-03-28

Log in to post a comment.