Converting MSSQL to mySQL

Discussion in 'Databases' started by Bigman012, Dec 30, 2011.

  1. #1
    I've been searching Google and haven't come up with a clear solution. I have pretty much zero experience with MSSQL, I need to convert an MSSQL database to work with mySQL. Any suggestions or information?
     
    Bigman012, Dec 30, 2011 IP
  2. JMDomains

    JMDomains Well-Known Member

    Messages:
    775
    Likes Received:
    15
    Best Answers:
    1
    Trophy Points:
    175
    #2
    JMDomains, Dec 30, 2011 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    I've done several large conversions in the past. http://www.navicat.com/ supports SQL server as well as MySQL. You can export into a text based format and then import into a MySQL database. Their premium version includes support for SQL server and MySQL. I can't think of an easier way to do it than this. It's not a free product but they do offer a 30 day trial. In my experience it is well worth the cost if you do a lot of database development.
     
    jestep, Jan 4, 2012 IP
  4. dgmdan

    dgmdan Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    MySQL has a migration toolkit which allows you to migrate from Microsoft SQL Server to MySQL. Personally though I haven't tried it.
     
    dgmdan, Jan 8, 2012 IP