MSSQL convertion to MySQL

Anon

I need to convert a Microsoft SQL database and its contents to a Mysql database... I´veno clue on how to do it and virtually impossible to feed a new db with teh data fom MMSQL...

If anyone knows how to do it...

Anon

You should script the tables in MSSQL, then recreate them on mySQL.

next, use MSSQL datatranpsortation wizard to export the table data to flat files and then just import the data into mySQL.

Or, you can write a program in windoze using VBScript + the mySQL ODBC driver program which copies the data from MSSQL to mySQL.

Maybe there is a tool somehint like the MSSQL Enterprise Manager with which you can do the above automagically.

In short, it can be done.

Michiel

dwilliams

This may not be a lot of help but...

Someone (Brian Andrews) wrote a VBA module for MS Access to convert it's structure and data to a MySQL friendly export.

This is still available as Office 97 and Office 2000 versions...

ftp://ftp.informate.co.nz/pub/

If you know a little about VBA or even VB, you could easily mock this up to communicate with MS SQL and possibly do the same thing.

Hope this helps,
DW

Anon

It can be done. The problem is not how to export data from one database server (mssql) to another one (mysql).
For this, if you dont't want to write your php script, you can install both mssql odbc and mysql odbc and then using access or something similar to accomplish the job. So you can read datas from mssql and write to mysql (think it's called data pumping).

The big problem is that there are a lot of differences between the two databases. (for a comparison look here: http://www.mysql.com/information/crash-me.php)
Therefore, only if the structure is "standard" probably you won't have problem for the port.

Good luck.
Paolo

dcaillouet

I did a conversion like this recently. For my particular database, it wasn't that hard. First I went into SQL Server Enterprise, right-clicked the database I wanted to convert and selected <All Tasks><Generate SQL Scripts>. I generated all the DDL for my tables, indexes, constraints, etc. and saved it to flat text file. I then used a text editor to globally change all of the MSSQL specific stuff: get rid of the "[]"'s and "dbo."'s, change all of the smalldatetimes to datetimes, etc. It took a few tries but the script eventually ran cleanly on MySQL.

Then it was simply a matter of BCPing the data out of MSSQL and using LOAD DATA INFILE to move it into MySQL.

Anon

i haven't done this before, but try it as simple as possible

create your tables in mysql (how to automate this, i have no clue) but then create a "myodbc" access db for the mysql and mssql database and do a simple copy'n'paste ?!?

mike