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; '[EMAIL PROTECTED] ' 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: [EMAIL PROTECTED] >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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
