RE: sql2000 to mysql

2004-08-24 Thread Victor Pendleton
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 Table

RE: sql2000 to mysql

2004-08-24 Thread Karam Chand
You can try SQLyog's ODBC Import feature. SQLyog can be found at http://www.webyog.com Regards Karam --- Tim Winters <[EMAIL PROTECTED]> wrote: > Hi Victor, > > Just Tables and Data. > > Ideally scripted to create the tables and insert the > data. will sql2000 > product something similer to a

RE: sql2000 to mysql

2004-08-24 Thread Tim Winters
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 proced

Re: sql2000 to mysql

2004-08-24 Thread Davut Topcan
Victor Pendleton wrote: Are you wanting to move Foreign keys, Triggers, Stored procedures and the like as well or just the data? definitely!! so you make relations in your codes for projects... If not use Triggers, not use Stored procedures then, You move database, table and data with a small

RE: sql2000 to mysql

2004-08-24 Thread Victor Pendleton
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