If you have DTS you can export the data to a CSV format. If you have MyODBC
installed you could export directly to MySQL.
From: Tim Winters
To: Victor Pendleton; 'mysql@stripped '
Sent: 8/24/04 11:34 AM
Subject: RE: sql2000 to mysql
Just Tables and Data.
Ideally scripted to create the tables and insert the data. will sql2000
product something similer to a .sql file which can simple be run as a
At 12:45 PM 24/08/2004, Victor Pendleton wrote:
>Are you wanting to move Foreign keys, Triggers, Stored procedures and
>like as well or just the data?
>From: Tim Winters
>Sent: 8/24/04 10:36 AM
>Subject: sql2000 to mysql
>Can someone advise me of the best/easiest way to move an entire DB
>and data) from sql2000 (my client) to mySQL (my System)?
>I need to advise someone on how I wish the data sent to me.
>Any help would be appreciated.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql