Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Indiana
    Posts
    420

    How-to Convert MSSQL 9 to MySQL?

    I'm trying to move my site from a local hosting company that uses MSSQL to a new host that uses MYSQL. I don't have shell access to either host and my current host has no control panel of any kind for me (such as cpanel, etc).

    I have a phpBB3 forum that I'd like to move to my new host but since my old host uses MSSQL I'm not having good luck moving it to the host that uses MySQL. The only utility I've got to use is the built in backup/restore that's in phpBB3, but since they use two different database types I think thats causing me my trouble now.

    Is there a converter of some kind that will convert a MSSQL .sql file to MySQL .sql file?

  2. #2
    Join Date
    Dec 2006
    Posts
    477
    It's a bit convoluted but one method that would probably work is:

    1. Install mssql and mysql both on a local machine. You should be able to use mssql express edition.

    2. Install the odbc drivers for mysql

    3. Restore your backup to mssql

    4. Use the import/export tables function in Microsoft SQL Management Studio to export the tables from the mssql database to the mysql using the odbc driver

    5. Backup the mysql database with mysqldump and upload this backup to your new host

    The only bit I'm unsure of is whether the export tables function is present in the free Express edition of the management studio. It's definitely there in the rest of the editions if you have access to one of those.

Similar Threads

  1. Convert a MSSQL to a MySQL db
    By thefandango in forum Hosting Security and Technology
    Replies: 7
    Last Post: 12-17-2009, 06:08 PM
  2. convert mysql to postgresql?
    By surfmanjoe in forum Programming Discussion
    Replies: 2
    Last Post: 06-12-2009, 11:21 PM
  3. MySQL Convert Passwords
    By -Edward- in forum Programming Discussion
    Replies: 6
    Last Post: 02-15-2008, 12:09 PM
  4. Convert Articles from CF/MSSQL to PHP/MySQL
    By Flywaver in forum Employment / Job Offers
    Replies: 3
    Last Post: 03-03-2005, 11:15 PM
  5. Convert MYSQL to MS Excel?
    By c3uc3 in forum Hosting Security and Technology
    Replies: 7
    Last Post: 08-13-2004, 09:36 AM

Posting Permissions

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