Re: Migration tools/plan from oracle 7.3 to Mysql 4.0With "application code", I meant that
- 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
- 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)
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
I had the application code. What will be the eqaulant of views in Mysql?. I mean
in what way i have to migrate the views, triggers, stored procedures and contraints of
Oracle to Mysql 4.0 classic version (This does not vave innodb engine).
From: Martijn Tonies [mailto:m.tonies@stripped]
Sent: Tue 8/17/2004 3:45 PM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER); mysql@stripped
Subject: Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
> Thank you for your response. Could any one give more
clarification on the alternatives for Views, Stored procedures, triggers and
contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot
support the InnoDB storage engine.
Well, what other alternative do you have but application code?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Confidentiality Notice The information contained in this electronic message and
any attachments to this message are intended for the exclusive use of the addressee(s)
and may contain confidential or privileged information. If you are not the intended
recipient, please notify the sender at Wipro or Mailadmin@stripped immediately and
destroy all copies of this message and any attachments.