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.
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 pretty easy to
figure out.
Next, create an ODBC DSN to the MSSQL7 database(s). The MySQL Server
can be
installed eithe ron the same machine or another machine that can
connect to
MSSQL7.
MySQLFront (http://www.mysqlfront.de/) can help you import the
MSSQL7 row
information into your MySQL database. Alternatively, you could link
tables
with MSAccess, but MySQLFront is easier and cleaner.
Gerald Jensen
From: "Bart Goormans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 8:11 PM
Hi all,
There's a fairly large MS SQLserver Database that my client wants me
to
convert to MySQL.
...
The main issue will be its size, so an intermediate tab-delimited
textfile
might not be useable.
Bart
--------------------------------------------------------------------
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
