Skip to main content
Question Protected by CommunityBot
added migration tag
Link
Derek Downey
  • 23.5k
  • 11
  • 78
  • 104
Tweeted twitter.com/#!/StackDBAs/status/76883373527801856
Source Link
murgatroid99
  • 371
  • 1
  • 2
  • 8

Need to migrate SQL Server to MySQL

I have a database on SQL Server 2008 on a Windows server and I want to move all of the data to a MySQL database on a Ubuntu server. I have tried using the SQL Server Import and Export Wizard with the MySQL ODBC driver, and it correctly accesses both databases, but the xml files containing the specifications for type conversion did not exist and the specifications were too limited for me to correctly create them. Does anyone know either how to create the type conversion files or where to get a better tool for transferring this data?