From: Martijn Tonies
Date: August 17 2004 10:29am
Subject: Re: Migration tools/plan from oracle 7.3 to Mysql 4.0
List-Archive: http://lists.mysql.com/mysql/171072
Message-Id: <02da01c48445$1f4a2820$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_02D7_01C48455.E2CBCC30"

------=_NextPart_000_02D7_01C48455.E2CBCC30
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

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-----=20
    From: Martijn Tonies [mailto:m.tonies@stripped]=20
    Sent: Tue 8/17/2004 3:45 PM=20
    To: Lakshmi NarasimhaRao (WT01 - TELECOM SERVICE PROVIDER); =
mysql@stripped=20
    Cc:=20
    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. =20

------=_NextPart_000_02D7_01C48455.E2CBCC30--