WEB Mass conversion of MsSQL to MySQL ????

Discussion in 'OT Technology' started by Josh, May 21, 2008.

  1. Josh

    Josh Guest

    I need to convert 50 databases on the same MSSQL server to a MySQL format. What would the quickest way be to go about this? Each DB has 30 or so tables so it would take too long to try and export them as CSV and insert to MySQL. There must be a utility for this.

    Any idears?
     
  2. fishbulb

    fishbulb Active Member

    Joined:
    Oct 29, 2001
    Messages:
    6,848
    Likes Received:
    4
    Location:
    md
  3. opie

    opie hi. OT Supporter

    Joined:
    Sep 29, 2004
    Messages:
    6,025
    Likes Received:
    0
    Location:
    AZ
    good fucking luck... lol
     
  4. o2

    o2 Witty Title Here OT Supporter

    Joined:
    Oct 4, 2005
    Messages:
    16,099
    Likes Received:
    12
    Location:
    Toronto
    export the DB like you normally would. then go into phpmyadmin and import it. It takes care of everything.

    if your DB is huge..... then you are screwed I guess.
     
  5. BlazinBlazer Guy

    BlazinBlazer Guy Witness to The De-Evolution of Mankind.

    Joined:
    Jul 24, 2002
    Messages:
    18,783
    Likes Received:
    0
    Location:
    Lansing, MI USA
    Hope you've got one hell of a powerful dedicated DB server to process all that shit :mamoru:
     
  6. Josh

    Josh Guest

    I figured it out. Exported the tables I needed 1 at a time to CSV, then mass imported with a php script
     
  7. EkriirkE

    EkriirkE Zika Xenu OT Supporter

    Joined:
    Jan 11, 2004
    Messages:
    14,799
    Likes Received:
    0
    Location:
    Dublin & San Francisco, CA
    lol
    shoulda looked into the mysql migratoe above
     

Share This Page