• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL Server 2008 to MySQL data migration  RSS feed

 
Rich Ramirez
Greenhorn
Posts: 19
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hi Guys,

I would like to ask if anyone here at coderanch has experience in migrating data from SQL Server to MySQL database?
Data includes, stored procedures, views, functions and triggers.

I had been searching for a free tool, but it doesn't fits what I need.

MySQL Workbench has Migration Wizard but does not include sp, views, triggers and functions in the migration.

I also would like to ask if how long will it take to finish if your project is so big.

Thanks guys! I'm hoping for a good and variety of suggestions that helps.
 
Paul Clapham
Sheriff
Posts: 22835
43
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would suggest looking at this article: Guide to Migrating from Microsoft SQL Server to MySQL.

I confess I haven't looked at it myself, but since it's on the MySQL site there's a good chance it's going to be useful.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!