Re: MySQL as reporting database between corporate db and users is it OK?

2002-03-18 Thread Rodney Broom
From: Philippe Cand <[EMAIL PROTECTED]> > - Is there a way to script MySQL to execute a list of commands then execute > the load query? Yep, Perl makes this whole list of tasks simple. Or possible, depending on your stance. If you don't write any Perl, then I'd say to use a batch script and wr

MySQL as reporting database between corporate db and users is it OK?

2002-03-18 Thread Philippe Cand
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