Scott Pippin [EMAIL PROTECTED]
>>> "Wesley Brown" <[EMAIL PROTECTED]> 11/20/02 11:24AM >>> >Well, This is my first attempt at moving from Oracle to MySQL on such a >large scale and so far it isn't going well at all. We are running oracle >7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total >of 45 millon records over. I have tried several diffrent methods including >using a MS-SQL server to act as go between using DTS services. We have run >into two problems, one, we don't get all the data over we loose rows and the >like. Two it is super slow on the order of 18 to 30 hours to do a pull. We >need a way to move the data in a resonable amount of time around 8 hours is >the goal. Things I have tried so far include using MS-SQL as a go between >fast but with data loss, using a custom ADO application to move the data and >handle any transforms we get the data but it REAL slow, and trying to get >the oracledump.pl perl script to run with no success. If anyone has had a >chance to do this type of migration please point me in the right direction. >I would really hate to stay with Oracle for the only reason that we can't >get the data off of it and on to another box :) >Thanks, >Wes Oracle has an export utility. Did you try that? We ran in to the same problems exporting our data from oracle to mysql. We used PowerBuilder(it has a data-pipeline feature under its database menu). This allowed us to connect through ODBC and create the table then import the data. Unfortunately we had to do this for each table. I hope this gives you a few more ideas. --------------------------------------------------------------------- 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
