Results 1 to 4 of 4

Thread: MS SQL -> mySQL

  1. #1

    MS SQL -> mySQL

    Does anyone know any good tool to convert MS SQL D/B to mySQL D/B?

  2. #2
    Join Date
    Jun 2001
    Denver, CO
    I am not sure about this, but you probably could use DTS in SQL Server to interface with the mySQL DB, assuming that the mySQL ODBC drivers were installed on the computer you're running Enterprise Manager on, and also assuming you have remote access to both mySQL and MS SQL.
    Jay Sudowski // Handy Networks LLC // Co-Founder & CTO
    AS30475 - Level(3), HE, Telia, XO and Cogent. Noction optimized network.
    Offering Dedicated Server and Colocation Hosting from our SSAE 16 SOC 2, Type 2 Certified Data Center.
    Current specials here. Check them out.

  3. #3
    You could use a product like DataJunction. It runs on a PC and uses ODBC to do it's work.

    I haven't used them in a while (since they got purchased by Pervasive).

  4. #4
    Join Date
    Dec 2003
    I'd use DTS on the MS SQL Box and the MySQL ODBC drivers.

    I'm assuming that you're only intersted in data and you don't have SP's, Triggers, Views etc.. in the MS SQL database.

    You'll probably have to re-apply users & permissions to the newly created tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts