[thelist] MySQL to SQL server

Steve Cook steve.cook at evitbe.com
Fri Jul 13 02:36:49 CDT 2001


If you're looking to get the data out in csv format, then the simplest step
might be to script it. Using PHP (or whichever favourite scripting language
you have), you could quite easily write a script that opens a table at a
time and simply parses the data into a csv format file.

Then you could use a MySQL generated script to create your DB tables in SQL
Server and import the data from your csv files.

Tada!!

Seriously - I hope that helps.

.steve


----------------------------
Steve Cook
web strategist
Evitbe AB tidigare Biljettpoolen
031-15 16 17   0703-13 26 31
steve.cook at evitbe.com     www.evitbe.com
---------------------------- 

> 
> Hello-
> 
> Does anyone know how you can get data from a MySQL database 
> to SQL server?
> Apparently you can't export a csv file, you can only export a 
> SQL script.
> Unfortunately, the sql script it writes out can't simply be 
> run because some
> of
> the values being inserted into varchar fields have 
> apostrophe's in them,
> thus causing a syntax error.
> 
> Thanks in advance, as usual,
> 
> Alice




More information about the thelist mailing list