Convert MySQL 5 to SQL 2005

• michael murphy-328430

  SSC Enthusiast

  Points: 193

  More actions

  February 7, 2008 at 8:17 am

  #186423

  I need to import data from a MySQL 5 database to SQL 2005.

  Problem is that I have not seem a MySQL provider in doing a import of the tables.

  The MySQL db has foreign keys so the order is important.

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  February 7, 2008 at 8:37 am

  #776048

  Download MyODBC available via http://www.mysql.com/products/connector/odbc/[/url]

  Tommy

  Follow @sqlscribe

• michael murphy-328430

  SSC Enthusiast

  Points: 193

  More actions

  February 7, 2008 at 9:27 am

  #776074

  Thanks Tommy, sorry for such a simple answer. I was to focused on the .Net connector and that just did not work.

  Thanks again.

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  February 7, 2008 at 1:05 pm

  #776156

  NP 🙂

  Tommy

  Follow @sqlscribe