Futzing around with SQL Server 2008

[BeauJangles]

I downloaded SQL server 2008 the other day, and I've been playing around with it. I have a whole bunch of data that I'd like to stash in there, but it's all coded for MySQL, not MSSQL. Is there any easy way to import it or transfer it? Right now, I do not have a MySQL database with the data in it, only a txt dump file.

 

[imported_Dhaval00]

What's the syntax of the text file? CSVs?

 

[BeauJangles]

Originally posted by: Dhaval00
What's the syntax of the text file? CSVs?

Actually, I have it separated into separate SQL DB creation queries (see attached code) and separate .csv files with the actual data.

 

[imported_Dhaval00]

http://rafb.net/p/jNrwZb12.html

For more info, look up BULK INSERT on MSDN. As a side note, is there a reason why you don't have an internal PK like an auto-incrementing BIGINT?