how to convert an oracle db into a mysql db

Discussion:

(too old to reply)

Moehre2002

2004-06-02 08:34:15 UTC

hi guys,
i´m trying to convert an oracle db into a mysql db. i tried the
application ora2sql.exe allready and it worked out fine. but the
problem is that i need to convert the procedures and the views, even
the synonyms too. and ora2sql doesn´t do this. so i downloaded and
installed maxdb by mysql. does anyone know how to use it.? the manual
is a little too big to find my answers and instructions. naybe you can
help me....

Jim Kennedy

2004-06-02 14:49:31 UTC

Permalink

Post by Moehre2002
hi guys,
iŽm trying to convert an oracle db into a mysql db. i tried the
application ora2sql.exe allready and it worked out fine. but the
problem is that i need to convert the procedures and the views, even
the synonyms too. and ora2sql doesnŽt do this. so i downloaded and
installed maxdb by mysql. does anyone know how to use it.? the manual
is a little too big to find my answers and instructions. naybe you can
help me....

The stored proc language isn't the same. I'm not sure mysql has a stored
proc language, which would make conversion difficult, but if it does I
guarantee it is very different.
Jim

Christopher Browne

2004-06-02 23:55:33 UTC

Permalink

Post by Jim Kennedy

The stored proc language isn't the same. I'm not sure mysql has a stored
proc language, which would make conversion difficult, but if it does I
guarantee it is very different.

MySQL(tm) only has a "stored procedure" language as of version 5.0,
which is the 'bleeding edge' version.

The vendor claims that they will support views in a future version,
but now is not the future.

If the goal is to convert from Oracle to a "free software" database
system, then perhaps it is necessary to consider other options that
have mature support for views and stored procedures such as Firebird
and PostgreSQL.

--
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://www3.sympatico.ca/cbbrowne/rdbms.html
"Es is nicht gasagt das es besser wird wenn es anders wirt. Wenn es
aber besser werden soll muss es anders werden. (Loosely translated:
Different is not necessarily better. But better _is_ necessarily
different.)" -- G. Ch. Lichtenberg

michael newport

2004-06-07 06:22:04 UTC

Permalink

or Ingres www.ca.com, it will shortly be open source

Christopher Browne

2004-06-07 08:49:31 UTC

Permalink

Post by michael newport
or Ingres www.ca.com, it will shortly be open source

We'll see what gets released.

It may be a similar scenario to when SAP decided to release SAP-DB
under an "open source" license. That code was ancient and crufty, and
never really attracted any "community" of interested developers.

Ingres isn't particularly new, so I'd think there to be a high risk of
"excessive cruftiness."

--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/internet.html
"This machine has a modular architecture, and the beauty of that is
that you can take all the boards out of it [does so...] and ... er ...
forget which order they go in" -- Arthur Norman

Paul

2004-06-08 17:17:05 UTC

Permalink

Post by Christopher Browne

Post by michael newport
or Ingres www.ca.com, it will shortly be open source

We'll see what gets released.
It may be a similar scenario to when SAP decided to release SAP-DB
under an "open source" license. That code was ancient and crufty, and
never really attracted any "community" of interested developers.

Did anyone run with a "real" OS version (like the split between Firebird
and Interbase), or has it been completely "MySQL'ed"?

Post by Christopher Browne
Ingres isn't particularly new, so I'd think there to be a high risk of
"excessive cruftiness."

Well, you should hear some of the FB developers give out about the
"cruft" left in the IB/FB codebase by Borland.

Paul...

--
plinehan y_a_h_o_o and d_o_t com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.

"XML avoids the fundamental question of what we should do,
by focusing entirely on how we should do it."

quote from http://www.metatorial.com

Christopher Browne

2004-06-09 12:44:26 UTC

Permalink

Post by Paul

Post by Christopher Browne

Post by michael newport
or Ingres www.ca.com, it will shortly be open source

We'll see what gets released.
It may be a similar scenario to when SAP decided to release SAP-DB
under an "open source" license. That code was ancient and crufty, and
never really attracted any "community" of interested developers.

Did anyone run with a "real" OS version (like the split between Firebird
and Interbase), or has it been completely "MySQL'ed"?

I'm convinced that SAP-DB went to MySQL AB as a place to get some
minimal maintenance to take place as they watch the product die. The
"win" is if MySQL AB can add enough features to the MySQL(tm) product
to make it usable for small, low-reliance R/3 installations.

Post by Paul

Post by Christopher Browne
Ingres isn't particularly new, so I'd think there to be a high risk of
"excessive cruftiness."

Well, you should hear some of the FB developers give out about the
"cruft" left in the IB/FB codebase by Borland.

The state of SAP-DB seems considerably further than that...

- It was written by mainframers;
- They used custom build tools that took considerable
time to port;
- They made massive use of 8 character symbols instead of
mnemnonic names;
- Any semblance of mnemonics in the names are lost due to
the fact that the developers used some sort of patois
combination of English and German.

--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','cbbrowne.com').
http://www.ntlug.org/~cbbrowne/lisp.html
Rules of the Evil Overlord #201. "All giant serpents acting as
guardians in underground lakes will be fitted with sports goggles to
prevent eye injuries." <http://www.eviloverlord.com/>

Roy Hann

2004-06-08 17:50:44 UTC

Permalink

Post by Christopher Browne

Post by michael newport
or Ingres www.ca.com, it will shortly be open source

We'll see what gets released.
It may be a similar scenario to when SAP decided to release SAP-DB
under an "open source" license. That code was ancient and crufty, and
never really attracted any "community" of interested developers.
Ingres isn't particularly new, so I'd think there to be a high risk of
"excessive cruftiness."

I know for sure that you are right about the "excessive cruftiness" of
certain source modules. But I was assured by one of the developers only
last week that the architecture itself is very clean, predictable, and
surprisingly easy to work with.

But unless the original poster has ambitions to delve into the guts of
Ingres and start tweaking he really shouldn't care how crufty the source
code is. He'd be getting a credible, proven, enterprise-ready, scalable,
robust, full-featured DBMS with legendary ease of management, for free.
(And of course Ingres supports views and DBPs.)

Roy Hann ( 'rhann' || 'rationalcommerce' dot 'com' )
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"