SQL Schema Converter News
Status: Alpha
Brought to you by:
evilpenguin
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!