There is one particular program that can dump an SQL Server database as
SQL statements much like mysqldump--its called SqlDump and it is
available from http://sqldump.sourceforge.net.
Ask your client to use it to give you the SQL file.
NOTE: the SQL stmts may be very much SQL Server specific tho
At 14:24 -0600 3/11/03, kenn murrah wrote:
Greetings.
I've been challenged with an assignment in which my client will feed
me a 9000-record SQL Server database every night, and I in turn
will need to import the data into mySQL, replacing the mySQL
database from the night before ...
Given that
CSV would be the easiest way.
-Shamit Verma
(http://vshamit.com)
- Original Message -
From: "kenn murrah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 12, 2003 1:54 AM
Subject: what's the best format option for importing SQL Server databas
Greetings.
I've been challenged with an assignment in which my client will feed me a 9000-record
SQL Server database every night, and I in turn will need to import the data into
mySQL, replacing the mySQL database from the night before ...
Given that scenario, and the fact that I obviously wan