SQL Schema Converter / News: Recent posts

Mostly.

I have successfully converted a SQL Server database and data from the same to MySQL with the script.

I had to forcibly convert a source column of type "uniqueidentifier" to something else. I am not particularly fond of Microsoft's love fo GUIDs, because they aren't! Most of them depend on something like either MAC, IP address, datetime, or random numbers to provide "uniqueness," all of which are not actually unique and are easily spoofed. Also, since the GUID is the result of running a hashing algorithm of that "factor" and something from the data, when you move "GUIDs" around, the probability of a collision increases dramatically. It is "good enough" programming, and while that has its place, an enterprise DBMS doesn't seem like that place to me.... read more

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
};... read more

This project has just been added to SourceForge. We are in the process of setting up the import of our CVS folder structure. Check back. The CVS baseline should be in by 2008-03-31.