[luau] migration

[Vikram Khurana]

Postgres also has the advantage when migrating from Oracle because
converting any existing PL/SQL code to PL/pgSQL is easy because of the
similarity between the 2 languages.

Mysql doesn't support stored procedures yet. So if you use stored
procedures, you can forget it.

Porting from PL/SQL
http://developer.postgresql.org/docs/postgres/plpgsql-porting.html
http://www.postgresql.org/docs/7.3/interactive/plpgsql-porting.html




-----Original Message-----
From: luau-admin at videl.ics.hawaii.edu
[mailto:luau-admin at videl.ics.hawaii.edu] On Behalf Of Gary Sublett
Sent: Tuesday, January 13, 2004 12:16 PM
To: luau at videl.ics.hawaii.edu
Subject: Re: [luau] migration

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 13 Jan 2004 11:40:17 -1000
"Lucas Halim" <dev-lists at verizon.net> wrote:

> Hi folks,
> 
> My department in UH-ITS is doing R&D on the possibility of replacing
> our Oracle database servers on Solaris in order to save cost. We are
> also looking into the possibility of replacing our Solaris boxes.
> First we need to sell our idea and convince the management. We are
> looking to test out SAP/MaxDB, MySQL, PostGre and DB2 on Suse, Red Hat
> or Debian to find the best performance combination. I'm wondering if
> anybody in the list had done this before or can provide any advice.
> 
I wouldn't waste my time considering MySQL for serious data management
work.  From your list, I suggest taking a close look at Postgresql on
your favorite linux distro or possibly better, consider freebsd for the
data server.  Just like Oracle, Postgresql performs best when properly
understood and tuned.

- ---
Gary

 17:14:08  up 5 days, 22:13, 10 users,  load average: 0.08, 0.18, 0.08



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFABG4tsU4FV1lLQCQRAgDyAJ9BzwR0a41k9oHJxeoO0MjZKxxR9QCdFja8
brHM7CPhgyLkrZSsv+Y0Iv0=
=jgnv
-----END PGP SIGNATURE-----
_______________________________________________
LUAU mailing list
LUAU at videl.ics.hawaii.edu
http://videl.ics.hawaii.edu/mailman/listinfo/luau