How do i copy a MSSQL table to MYSQL?

Discussion in 'Databases' started by Tintumol, Dec 14, 2010.

  1. #1
    I have a table in my mssql server that i need to move over to mysql. I dont even need all of the info, just 3 fields of the table.

    Any ideas of an easy way to export (from MSSQL) and import (into MYSQL)?

    Thanks!
     
    Tintumol, Dec 14, 2010 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    I don't know much about MSSQL. But I think you can export data in text format from MSSQL. If this is true then you can use LOAD DATA INFILE to import data to MySQL.
     
    mwasif, Dec 14, 2010 IP
  3. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #3
    Take a look at my signature ...
     
    graformix, Dec 14, 2010 IP
  4. duben

    duben Active Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #4
    You can use export from MSSQL to CSV file, and Import in MySQL

    Also you can use OLE DB connection, and make direct data transfer from MSSQL to MySQL
     
    duben, Dec 15, 2010 IP
  5. sqldev78

    sqldev78 Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Use SQL Data Examiner 2010. The tool works with MSSQL, MySQL, Oracle... This tool is not free, but free 30-day trial is available
     
    sqldev78, Dec 20, 2010 IP
  6. getbestproduct

    getbestproduct Peon

    Messages:
    140
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You can try this tools
     
    getbestproduct, Dec 23, 2010 IP
  7. 4asrir

    4asrir Greenhorn

    Messages:
    24
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #7
    you can access to the specific table you want and make edit and copier , then go to the same place in your sql and coller ,, that's what i do
     
    4asrir, Dec 29, 2010 IP
  8. generak002

    generak002 Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    in phpmyadmin
     
    generak002, Jan 1, 2011 IP
  9. Jeniffer Joan

    Jeniffer Joan Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Create a DTS task using SQL Server as the source and MySQL (via MyODBC) as the target.
     
    Jeniffer Joan, Jan 7, 2011 IP