Bringing data from a mySQL db server to SQL Server

• rjjh78

  SSCrazy

  Points: 2787

  More actions

  October 4, 2016 at 5:38 pm

  #321870

  Hello,

  Is there a way (other than OPENQUERY) to pull data from a MySQL database to a SQL Server database?

  Currently, I am using the following:

  SELECT * FROM OPENQUERY (MY_LINKED_SERVER_NAME, 'SELECT * FROM TestDBName')

  I am just looking to find if there is a better way to do this. Would SSIS be better or does that also use OPENQUERY?

• linshi07

  SSC Rookie

  Points: 33

  More actions

  October 5, 2016 at 8:29 am

  #1904924

  I believe the method in the linked below should be more general

  http://forums.mysql.com/read.php?60,585162,585162