Export tables to MySQL

• DBA Cabuloso

  SSCommitted

  Points: 1733

  More actions

  July 24, 2009 at 1:55 pm

  #134607

  Hi pals,

  What is the best, or easiest way of transfering table structures from SQL Server 2005 to MySQL?

  I have both MSSQL and MySQL installed on my machine and I couldn't find in the SSIS any connection handler to MySQL.

  I don't have a CASE tool here in my environment, so I really would like to use the SSIS.

  Thanks in Advance,

  Lucas

  DBA Cabuloso

  ________________
  DBA Cabuloso
  Lucas Benevides

• LutzM

  SSC Guru

  Points: 107049

  More actions

  July 24, 2009 at 2:17 pm

  #1030047

  Hi Lucas,

  maybe this post will be useful.

  I found it using the search keywords "linked server mysql" on this site.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• DBA Cabuloso

  SSCommitted

  Points: 1733

  More actions

  July 24, 2009 at 2:32 pm

  #1030057

  Do I have to create a linked server?

  Even if I want to use the SSIS I have to do it?

  I really thought Microsoft considered this scenario.

  Lucas DBA

  ________________
  DBA Cabuloso
  Lucas Benevides

• LutzM

  SSC Guru

  Points: 107049

  More actions

  July 25, 2009 at 12:43 pm

  #1030197

  You don't "have to".

  There are -almost- always alternatives.

  Maybe this blog describes an alternative for you.

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]