Re: Migrating from MS SQLserver to MySQL
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 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
RE: Migrating from MS SQLserver to MySQL
Thanks Schajee, Did you let Access make an SQL-script to build your tables ? You could then use such scripts in mySQL to produce a copy of the database. And what would you be using for the import of the data ? cheers, bart -Oorspronkelijk bericht- Van: Schajee Achmad [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 query. What access did was it generated an SQL query that was run on MySQL and that sort of imported/converted all data to MySQL. Try that same thing MS SQL. I'm sure there'll be someting that might do that. --- Bart Goormans [EMAIL PROTECTED] wrote: 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 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - 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
Re: Migrating from MS SQLserver to MySQL
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
RE: Migrating from MS SQLserver to MySQL
'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: Wednesday, August 08, 2001 6:11 PM To: [EMAIL PROTECTED] 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
RE: Migrating from MS SQLserver to MySQL
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