Import data from MS SQL to MYSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ddtpmyra
    Contributor
    • Jun 2008
    • 333

    Import data from MS SQL to MYSQL

    I never done this before, anybody who can help me how to do this?

    Currently I have produce .rpt from the result query from MS SQL now my problem is how to load this table on MYSQL

    Please help and thanks!
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    There is no standard way of migrating data from a MSSQL database to MySQL. They are two entirely different things.
    You could probably find some tools to help you do it though.

    Personally, I would just re-create my MSSQL table in my MySQL database, export the data from MSSQL to a CSV file and then import that into my new table in my MySQL database.

    Comment

    • mwasif
      Recognized Expert Contributor
      • Jul 2006
      • 802

      #3
      Did you try MySQL migration toolkit?

      Comment

      Working...