Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.

Mohan, Ross wrote:

Hello Postgres'ers,

Oracle newbie to PG here, curious about best books and online
resources. A *lot* of what I am finding in google is one to four year
old p*ssing contest with MySQL vs. Postgres (don't care) or "Why
doesn't PostGres support five level hypergalactic triple ACID Phase
Inverters on the Debian/Slack Leenucks 3.0(a) kernel" (also don't
care, at least yet ;-))

Just have a small oracle db to move over to PG. And I want it to go
well, be robust, manageable etc. So...that's the kind of
book/community I am looking for.

Any pointers?

Having recently done this myself, check out ora2pg. Very helpful, and
will do much of the work for you. There are also section in the
documentation dealing with this particular topic (since so many people
want to do it.)

Thanks In Advance!

Ross Mohan
Postgres Rookie

---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend

--
Guy Rouillier

Probably there is a more recent link. This is the one that popped up in
Google:
http://www.postgresql.org/docs/7.3/interactive/plpgsql-porting.html

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mohan, Ross
Sent: Tuesday, March 29, 2005 4:35 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Oracle Migration. Don't Care about the Corbomite
Maneuver, Spock.

Hello Postgres'ers,

Oracle newbie to PG here, curious about best books and online
resources. A *lot* of what I am finding in google is one to four
year old p*ssing contest with MySQL vs. Postgres (don't care)
or "Why doesn't PostGres support five level hypergalactic triple ACID
Phase Inverters on the Debian/Slack Leenucks 3.0(a) kernel" (also
don't care, at least yet ;-))

Just have a small oracle db to move over to PG. And I want it
to go well, be robust, manageable etc. So...that's the kind
of book/community I am looking for.

Any pointers?

Thanks In Advance!

Ross Mohan
Postgres Rookie

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Here's a newer link:
http://www.postgresql.org/docs/8.0/interactive/plpgsql-porting.html

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mohan, Ross
Sent: Tuesday, March 29, 2005 4:35 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Oracle Migration. Don't Care about the Corbomite
Maneuver, Spock.

Hello Postgres'ers,

Oracle newbie to PG here, curious about best books and online
resources. A *lot* of what I am finding in google is one to four
year old p*ssing contest with MySQL vs. Postgres (don't care)
or "Why doesn't PostGres support five level hypergalactic triple ACID
Phase Inverters on the Debian/Slack Leenucks 3.0(a) kernel" (also
don't care, at least yet ;-))

Just have a small oracle db to move over to PG. And I want it
to go well, be robust, manageable etc. So...that's the kind
of book/community I am looking for.

Any pointers?

Thanks In Advance!

Ross Mohan
Postgres Rookie

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Mohan, Ross wrote:

Hello Postgres'ers,

Oracle newbie to PG here, curious about best books and online
resources. A *lot* of what I am finding in google is one to four
year old p*ssing contest with MySQL vs. Postgres (don't care)
or "Why doesn't PostGres support five level hypergalactic triple ACID
Phase Inverters on the Debian/Slack Leenucks 3.0(a) kernel" (also
don't care, at least yet ;-))

Just have a small oracle db to move over to PG. And I want it
to go well, be robust, manageable etc. So...that's the kind
of book/community I am looking for.

Any pointers?

If you don't currently use store procedures your data set
should be fairly easily to move over. You just have to change
some data types to correctly match.

I had a paper around here somewhere about it I will see if I can
did it up.

Sincerely,

Joshua D. Drake

Thanks In Advance!

Ross Mohan
Postgres Rookie

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

On Wed, Mar 30, 2005 at 00:35:25 -0000,
"Mohan, Ross" <RMohan@arbinet.com> wrote:

Any pointers?

The online documentation is very good. For generic Postrges questions, that
is probably your best resource. There may be better places to get answers
about questions on converting from Oracle to Postgres.

BW -

Thanks....now that it's downloaded and printing..i see what you mean. And
I agree.

I am utterly STUNNED and happy to see PG uses GA for query optimization;
that, by itself, just makes this whole process that much more fun...

- RM

-----Original Message-----
From: Bruno Wolff III [mailto:bruno@wolff.to]
Sent: Wednesday, March 30, 2005 12:36 PM
To: Mohan, Ross
Cc: pgsql-general@postgresql.org
Subject: Re: Oracle Migration. Don't Care about the Corbomite Maneuver, Spock.

On Wed, Mar 30, 2005 at 00:35:25 -0000,
"Mohan, Ross" <RMohan@arbinet.com> wrote:

Any pointers?

The online documentation is very good. For generic Postrges questions, that is probably your best resource. There may be better places to get answers about questions on converting from Oracle to Postgres.