import mysql .sql file to sql server

  • Hi,

    I have a 600 meg .sql mysql table on my local computer. I loaded the file into mysql no problem.

    How can I import this beast into SQL Server?

    Really lost!

  • Provided there aren't any syntax issues (MySQL and Microsoft SQL Server doesn't have exactly the same SQL syntax but most of it is the same), you can isql or osql.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • ok I don't know much about isql or osql...is it easy enough for you to tell me?

  • Both utilities are explained in Books Online.

    I would first take a look at the CREATE TABLE statements in ths *.sql file.

    There are some (minor) differences between MySQL and SQL Server.

    AFAIK there are transfer tools available. If that could be an alternative, google on this.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • The file is too big and it can't be open in any editor that I have tried.

    Its 600 megs.

  • Try TextPad. There are a few others (everyone post your favorite time). These types of text editors don't open up the whole file initially, hence the reason they work.

    http://www.textpad.com/

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    Edited by - bkelley on 12/19/2003 06:45:40 AM

    K. Brian Kelley
    @kbriankelley

  • If you have the mySQL ODBC Driver (I believe it comes with mySQL for Windows), you should be able to use DTS. The shortcut is labled "Import and Export Data", and it's fairly self-explainatory.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply