December 18, 2003 at 5:02 pm
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!
December 18, 2003 at 8:16 pm
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
K. Brian Kelley
@kbriankelley
December 18, 2003 at 9:59 pm
ok I don't know much about isql or osql...is it easy enough for you to tell me?
December 19, 2003 at 1:01 am
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
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 19, 2003 at 5:37 am
The file is too big and it can't be open in any editor that I have tried.
Its 600 megs.
December 19, 2003 at 6:45 am
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.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
Edited by - bkelley on 12/19/2003 06:45:40 AM
K. Brian Kelley
@kbriankelley
December 19, 2003 at 2:34 pm
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