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
- 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)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
Upscene Productions
http://www.upscene.com
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).
Thanks,
Narasimha
919845682459
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@stripped]
Sent: Tue 8/17/2004 3:45 PM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER); mysql@stripped
Cc:
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?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
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.
