List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:August 24 2004 5:58pm
Subject:RE: sql2000 to mysql
View as plain text  
If you have DTS you can export the data to a CSV format. If you have MyODBC
installed you could export directly to MySQL.

-----Original Message-----
From: Tim Winters
To: Victor Pendleton; 'mysql@stripped '
Sent: 8/24/04 11:34 AM
Subject: RE: sql2000 to mysql

Hi Victor,

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
script?

Thx

At 12:45 PM 24/08/2004, Victor Pendleton wrote:
>Are you wanting to move Foreign keys, Triggers, Stored procedures and
the
>like as well or just the data?
>
>-----Original Message-----
>From: Tim Winters
>To: mysql@stripped
>Sent: 8/24/04 10:36 AM
>Subject: sql2000 to mysql
>
>Hello,
>
>Can someone advise me of the best/easiest way to move an entire DB
>(Tables
>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.
>
>Thanks,
>
>Tim
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
Thread
sql2000 to mysqlTim Winters24 Aug
RE: sql2000 to mysqlVictor Pendleton24 Aug
  • Re: sql2000 to mysqlDavut Topcan24 Aug
  • RE: sql2000 to mysqlTim Winters24 Aug
    • RE: sql2000 to mysqlKaram Chand24 Aug
RE: sql2000 to mysqlVictor Pendleton24 Aug