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.