mySQL -> msSQL

Hello all,

I spent the last two days trying to find an application that can export a mySQL database into msSQL syntax so that I can then use that to just create my msSQL database. I have had no such luck, though I could find a bunch to do msSQL to mySQL.

Please let me know if anyone has one or knows of one that works because I really do not want to hand port my 70 table database from mySQL to msSQL

Thanks in advance,

Anthony F Greco

DO you want application tool?

i found these two sites, not sure if it helps

http://www.softplatz.com/Soft/Network-Internet/Other/MySQL-MS-SQL-Server-Import-Export-Convert-Software.html

http://mysql-to-sql-server.qarchive.org/

|||Yes I did see them, I was just hopping to find a freeware one. If not I will go with one of them though. Thanks for the help =]|||

Hey

You could take a look at this:

Migrating MySQL to Microsoft SQL Server

I've done this before and just want to remind you that MySql is case sensitive but Sql server is not ,for example:

You hava column A(pk) B with values:

valueA valueB

valuea valueb

Sql Server will complain about violation ofprimary key constraint .

Hope this helps.