Re: Migration tools/plan from oracle 7.3 to Mysql 4.0

[Michael Stassen]

Martijn Tonies wrote:
> Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant
> that you:
> 
> - have to change your queries so that they include the full VIEW sql,
>   because MySQL doesn't have an alternative
> - have to recreate your stored procedures in application code and do you
>   work at the client or a middle tier

MySQL 5 has stored procedures.  Of course, it's still alpha.

> - have to recreate all your triggers in application code to do additional
>    work instead of the triggers on the database
> - have to bring your checks into the application (but they won't be safe
>   anyway, 'cause MySQL Classic doesn't have transactions)

Well, if you need transactions, then why not use MySQL 4 Standard (or Pro) 
which does support InnoDB tables and transactions?

> With regards,
> 
> Martijn Tonies

Michael