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
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
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
'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
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