List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 17 2004 10:29am
Subject:Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
View as plain text  
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.  

Thread
Migration tools/plan from oracle 7.3 to Mysql 4.0lakshmi.narasimharao17 Aug
  • Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Martijn Tonies17 Aug
RE: Migration tools/plan from oracle 7.3 to Mysql 4.0lakshmi.narasimharao17 Aug
  • Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Martijn Tonies17 Aug
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Martijn Tonies17 Aug
  • Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Michael Stassen17 Aug
Re: Migration tools/plan from oracle 7.3 to Mysql 4.0Martijn Tonies17 Aug
RE: Migration tools/plan from oracle 7.3 to Mysql 4.0lakshmi.narasimharao25 Aug
  • RE: Migration tools/plan from oracle 7.3 to Mysql 4.0Karam Chand25 Aug