0

Whats the best method and or tools to move a MsSQL database to MySQL ?

Please be as literal as possible as I have limited experience with databases and next to none with moving them.

Lightness Races in Orbit
  • 378,754
  • 76
  • 643
  • 1,055
RY4N
  • 1,080
  • 3
  • 14
  • 31
  • 1
    check structure! check if all needed data types are represented in both RDBMS. check if there are UDF or SP in MSSQL which have to be rewritten manually. check if there are triggers... – rabudde Sep 20 '11 at 11:40
  • see: http://stackoverflow.com/questions/7279303/how-to-convert-mssql-database-to-mysql-database and http://stackoverflow.com/questions/1770795/convert-mysql-script-to-mssql – Kevin Burton Sep 20 '11 at 12:19

1 Answers1

2

MySQL itself offers a Migration Toolkit, which - in my experience - works rather well, not only with SQL-Server, and is as easy as it can get.

Documentation: http://dev.mysql.com/doc/migration-toolkit/en/index.html

Bjoern
  • 15,934
  • 4
  • 43
  • 48