SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member DroppedAtBirth's Avatar
    Join Date
    Apr 2001
    Location
    Tempe, Az
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Convert DB from MSSQL to MySQL

    What is the best way to convert a MSSQL DB to a MySQL DB? Database consist of 61 table and 500,000+ records.
    ~~~~~~~~~~~~~~~~~~~~~
    Robert Ward
    webmaster@droppedatbirth.com
    ~~~~~~~~~~~~~~~~~~~~~

  2. #2
    Gone!
    Join Date
    Aug 2001
    Location
    Witty Location Parody
    Posts
    3,889
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I cant comment on the best way, but have you heard of these guys.

    http://www.realsoftstudio.com/

    You can get a trial download and give it a whirl if its just one off.

  3. #3
    SitePoint Member DroppedAtBirth's Avatar
    Join Date
    Apr 2001
    Location
    Tempe, Az
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I just found that about a minute before you posted.

    I already tried using http://www.convert-in.com/ programs to convert to mssql -> access -> mysql

    couldn't get half the table to even convert to access correctly.


    I just downloaded Realsoftstudios software. Will try it.
    ~~~~~~~~~~~~~~~~~~~~~
    Robert Ward
    webmaster@droppedatbirth.com
    ~~~~~~~~~~~~~~~~~~~~~

  4. #4
    SitePoint Member DroppedAtBirth's Avatar
    Join Date
    Apr 2001
    Location
    Tempe, Az
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking It works

    Realsoftstudios software converter works great. I found a little bug in it but figured it out. Althought the trial version only converts up to 10 tables with 1000 records each - it is enought to see it works great.
    ~~~~~~~~~~~~~~~~~~~~~
    Robert Ward
    webmaster@droppedatbirth.com
    ~~~~~~~~~~~~~~~~~~~~~


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •