Exporting database from MS SQL to MySQL 1

[multiplex77]

Hi,

I'm trying to use Microsoft SQL Server Enterprise Manager's Data Import/Export Wizard to export my SQL Server database to MySQL. However I don't know which Destination server to choose to export to. Has anyone done this before? Would appreciate any advice. Thanks.

On a separate issue, does MySQL support stored procedures?

Thanks for the help!

 

[sleipnir214]

I'm not sure if you can use the import/export wizard to do this, but I'm positive you're not going to be able to do a server-to-server transfer. Mi¢ro$oft's software doesn't speak MySQL natively.

You might be able to do it via the MyODBC ODBC driver, available at

http://www.mysql.com.

Barring that, you may have to export your database to SQL statements, then modify them to conform with MySQL's column types, etc, then import the SQL into MySQL.

Another thing that may be of help is an app called "EMS MySQL Manager", which I know can suck data out of Excell spreadsheets and Access databases, then insert the data into MySQL. It's not a free app, but has a 30-day demo you might want to try. Look in Google for "EMS MySQL Manager".

MySQL does not yet support stored procedures. The authors plan on having that feature implemented in version 5.0, projected to be released at the end of this year. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[tatum]

I found a good mySQL front end program called mySQLfront. Even though its development has stopped, it is a good program. It has import/export capability that you could use.

You can find it at

http://mysqlfront.sstienemann.de/

Give it a try.

 

[multiplex77]

Thanks a lot tatum. I'll try it out.

 

[multiplex77]

Sorry forgot to thank sleipnir214... THANK YOU sleipnir214 for your help too!

 

[karam]

Try SQLyog at

http://www.webyog.com/sqlyog/download.html

It has the best ODBC Import Wizard seen till date and its FREE !!! and its also not defunct like MySQL-Front