Hello, I would like to use MySQL as a fast reporting database for a dotnet EIS. The source of the data is mainly 4 different huge and slow corporate db; Oracle 7, Oracle 8, Oracle 9 and MS SQL I need to perform daily load of tables at night. The load can be either Append or Replace. I have the sql queries to extract the data I need from the corporate db. My questions are as follow: - Is there a way to script MySQL to execute a list of commands then execute the load query? - Is it possible to query a corporate db from within MySQL using existing native Oracle SQL queries? - Is it possible to have these queries ran automatically every nights? - I will have to load daily about 10M rows accross about 20 tables . Is going to fit in a 3 hours time frame? - Which would be the best MySQL version for this application which loads data and serve it. I do not use the transactions. I could install MySQL on the D drive of a win2k/1GB Ram server, I have 25GB free on the D drive. is it going to be OK?
Thank you to answer to these very general questions. I do not have MySQL yet, I just want to check if it suitable for a reporting system Regards, Philippe Cand ON Semiconductor Finance --------------------------------------------------------------------- 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
