Post reply

Export tables to MySQL

  • 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

  • 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]

  • 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

  • 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]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply