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
----- Original Message -----
From: "Bart Goormans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 8:11 PM
Subject: Migrating from MS SQLserver to MySQL
Hi all,
There's a fairly large MS SQLserver Database that my client wants me to
convert to MySQL. Can someone advice me on how to tackle this, or direct me
to some help.
There aren't any BLOBs-fields or other exotic field types, mainly
straightforward text/integers, so I don't expect too much problems on that.
The main issue will be its size, so an intermediate tab-delimited textfile
might not be useable.
(?)
Thanks,
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
