Create a DTS job to export each table into a text file. Additionally, you
can use Query Analyzer to grab schema for each table (minor changes to sql
to use same code in mySQL). Create your tables, do a bulk insert.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 12:08 PM
Subject: Port MS SQL Database To MySQL ??
>
> Are there any tools avalable to port MS SQL to MySQL? I am only trying to
build up a bigger database for some testing and wanted to use the northwind
or one of thoses. If not where could I get one that's fairly big I could
load.
>
> Cheers
>
> Mike Benzel [EMAIL PROTECTED]
> Cross Platform Messaging and TDataSet Components: TAstaPDADataSets
> Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux
PDA's)
> ASTA Technology Group http://www.astatech.com
>
>
>
> ---------------------------------------------------------------------
> 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
