I want to insert data from MS sql to MYsql table

• santoshtk2003

  SSC Rookie

  Points: 36

  More actions

  August 4, 2010 at 10:53 am

  #146494

  I really impressed the way you had provided the linked server details but I am stuck and want to insert data from MS sql 2005 to mysql.

  Regards,

  Santosh Waghmare

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  August 4, 2010 at 11:10 am

  #1202227

  Have you considered using SSIS to do this? You can select the data from one database and insert that data through a control flow item into a different db destination.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  August 4, 2010 at 1:29 pm

  #1202347

  You may find this white paper useful

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• balaji.ganga

  SSCrazy

  Points: 2280

  More actions

  August 6, 2010 at 3:31 am

  #1203321

  Hi..

  Or else you can import those data into excel sheet and saved in a folder. then you can export the file

  into mysql database.

  With thanks & Regards

  Balaji.G