Re: Migrating from MS SQLserver to MySQL

2001-08-09 Thread Michael Kofler
try mssql2mysql; this is a VB/VBA script which can connect directly to MySQL, thus eliminating the need of temporary files http://www.kofler.cc/mysql/mssql2mysql.html Best wishes, Michael Kofler - Before posting, please c

RE: Migrating from MS SQLserver to MySQL

2001-08-09 Thread Bart Goormans
mailto:[EMAIL PROTECTED]] > Verzonden: donderdag 9 augustus 2001 7:45 > Aan: Bart Goormans > Onderwerp: Re: Migrating from MS SQLserver to MySQL > > > I had an almost similar problem with conversion from > Access to MySQL and that was easily solved by > generating an SQL

RE: Migrating from MS SQLserver to MySQL

2001-08-08 Thread Bart Goormans
I'll look into this, Thanks, bart goormans (will be following up on this thread shortly ...) Van: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 9 augustus 2001 3:53 Bart: There are many ways to skin this cat, but this is one we have used recently with good success. Cr

RE: Migrating from MS SQLserver to MySQL

2001-08-08 Thread Bart Goormans
'DTS' the information ? Sorry Edgart, what exactly do you mean by that ? bart From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]] augustus 9, 2001 3:39 You can DTS you information from MsSql to MySQL via ODBC. -Original Message- From: Bart Goormans [mailto:[EMAIL PROTECTED]] Sent: Wedn

Re: Migrating from MS SQLserver to MySQL

2001-08-08 Thread Gerald R. Jensen
Bart: There are many ways to skin this cat, but this is one we have used recently with good success. Create a script in MSSQL7 (you can do it through the Enterprise Manager) so can re-create the database schema in MySQL. There are some syntax differences between MSSQL7 and MySQL, but it is prett