RE: [PHP-DB] Oracle -> MySQL Datawarehouse

Hi Mark, Try www.openlinksw.com/virtuoso It's free for under 3 concurrent connections (which should be enough for the db dump) works well with PHP, and we have several people using it with over 25gig stored. Feel free to ask for any additional details off-list. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Nold, Mark [mailto:Mark.Nold@normandy.com.au] > Sent: Monday, November 20, 2000 11:04 PM > To: 'php-db@lists.php.net' > Subject: [PHP-DB] Oracle -> MySQL Datawarehouse > > > ------------------------------------------------------------------ > ---------- > ----------------- > Disclaimer: The information contained in this email is intended > only for the > use of the person(s) to whom it is addressed and may be confidential or > contain legally privileged information. If you are not the intended > recipient you are hereby notified that any perusal, use, distribution, > copying or disclosure is strictly prohibited. If you have received this > email in error please immediately advise us by return email at > postmaster@normandy.com.au and delete the email document without making a > copy. > ------------------------------------------------------------------ > ---------- > ----------------- > Hi people, > > We are think about using MySQL as a Datawarehouse for our Oracle DB. > > What we plan on doing is have a nightly job that updates tables in our DW. > > The production DB has 1000 tables and about 18Gb of data. > > The first step will be to simply duplicate the tables we plan on using on > the DW box. Once this is finished we'll create some denormalised > tables for > easy joininig etc on the Dataware from the now refreshed tables > or possibly > core data. > > My questions are: > > 1. What is the most efficient way of getting the data from Oracle > to MySQL? > Dump whole tables then upload? Simply SELECT * FROM mytable and > INSERT into > the MySQL DB? > > 2. Can MySQL handle 6-9GB of Data? > > 3. Any ideas of the Oracle Data Dump file format? Maybe we could make a > reader for this for the MySQL import... > > 4. Any similiar experiences? > > > Thanks, > > mn > > Mark Nold > markn@enspace.com > Senior Consultant > > Change is inevitable, except from vending machines. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >