No subject

PL/SQL is not a biggie but it's definitely good to know.

We are in the process of getting in new boxes and will try out Fedora also.

Thanks guys for the responses. Just keep it coming. 

Lucas

> -----Original Message-----
> From: luau-admin at videl.ics.hawaii.edu [mailto:luau-admin at videl.ics.hawaii.edu] On Behalf Of Vikram
> Khurana
> Sent: Tuesday, January 13, 2004 1:36 PM
> To: luau at videl.ics.hawaii.edu
> Subject: RE: [luau] migration
> 
> 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
> 
> _______________________________________________
> LUAU mailing list
> LUAU at videl.ics.hawaii.edu
> http://videl.ics.hawaii.edu/mailman/listinfo/luau