transfer data from sqlserver to mysql server

Discussion in 'PHP' started by mehdiali, Jun 19, 2009.

0
  1. #1
    Hi
    there is a sqlserver db that hold flies information.
    now i want to transfer those data to a mysql server in the web
    to use in fly information page.
    (read from sqlserver and send for mysql)
    what should i do?
    thank you
     
    mehdiali, Jun 19, 2009 IP
  2. FDIM

    FDIM Member

    Messages:
    55
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #2
    Am not familiar with sqlserver, but if i would need to do what you need. I would select all the data and make proper sql query to insert,create tables with php or asp or any other.
     
    FDIM, Jun 20, 2009 IP
  3. ezprint2008

    ezprint2008 Well-Known Member

    Messages:
    611
    Likes Received:
    15
    Best Answers:
    2
    Trophy Points:
    140
    Digital Goods:
    1
    #3
    Output the txt file (or however you want the code) of Sql.
    Edit it if needed to upload it to the MySql.

    Never tried it , but if its anything similar it should be able to be output and then uploaded to the new db
     
    ezprint2008, Jun 20, 2009 IP
  4. Sudoku-Master

    Sudoku-Master Peon

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    maybe you can export the data as csv and import it to mysql, I think its the easiest way...
     
    Sudoku-Master, Jun 20, 2009 IP