1. Generate SQL script for your database in the MS SQL Server Enterprise
Manager
2. Modify generated SQL to be compatible with MySQL
3. Run the script on your MySQL server
Pretty easy if you aren't using any feature of MS SQL that MySQL doesn't
support (for example stored procedures)
Another way is to connect both the servers to Access using ODBC and just
copy the tables - it's the easiest way to do that but resulting MySQL tables
are quite screwed up.
Pavel
----- Original Message -----
From: "Jason Bouwmeester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 25, 2001 4:44 PM
Subject: [PHP] SQL Server DB to mySQL DB
> Is there an easy way to do this? I know that SQL Server can export a comma
> delimited file, can mySQL import this? I imagine the PHP will be easy to
> modify as long as the field names are the same.
>
> Thanks,
> jb
>
> Jason Bouwmeester
> New Media Consultant
> InterVisual
>
> Suite 200, 709 - 11th Ave SW
> Calgary, AB T2R 0E3
> Ph: 403.264.9199
> Fax: 403.264.9225
> www.intervisual.com
> "Internet Solutions Developer"
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
