Curtis ...
Do you have the database/table created on the MySQL server? If so, you can
use MSAccess (need ODBC connections to both servers) to Link Tables and move
the data acros that way.
We did it that way until our programmers wrote a C++ app that replicates
server-to-server.
Gerald Jensen
----- Original Message -----
From: "Curtis Spencer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 2:54 PM
Subject: M$ SQL Export to Mysql Help
> I have a nicely sized database of about 400000 records, which I have in
> MS SQL but I need to move it to my production server, which is Mysql. I
> was going to do it this way:
>
> Export MS SQL database into a file and then use LOAD DATA INFILE
>
> But I was wondering if there were a way to export into SQL and then just
> use \. Database.sql to import it very quickly. I am worried that the
> exporter will mess up the file because it is so large.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
