ok, this is what's going on. i have this VB.NET
<http://www.experts-exchange.com/Databases/PostgreSQL/Q_21177281.html>
application with Oracle
<http://www.experts-exchange.com/Databases/PostgreSQL/Q_21177281.html>
8.1.7 back end, but now i have to switch the whole thing to PostgreSQL.
how do i do that? it's a big database
<http://www.experts-exchange.com/Databases/PostgreSQL/Q_21177281.html> ,
about 135 tables, a lot of views, triggers, a few stored procedures and
functions. i understand there are tools that do that. any
recommendations?

Thanks.

On Wed, 2004-10-20 at 13:47, Vassilev, Lubomir G. wrote:
There's a directory under postgresql-x.y.z/contrib called oracle that
has some helpful scripts.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Thanks for your reply, however as I am a total newbie around here, I've
no clue how to get to postgresql-x.y.z/contrib. I looked on the main
page but couldn't find it.

-----Original Message-----
From: Scott Marlowe [mailto:smarlowe (AT) qwest (DOT) net]
Sent: Saturday, October 23, 2004 7:10 PM
To: Vassilev, Lubomir G.
Cc: pgsql-general (AT) postgresql (DOT) org
Subject: Re: [GENERAL] how to port Oracle database to PostgreSQL?

On Wed, 2004-10-20 at 13:47, Vassilev, Lubomir G. wrote:
There's a directory under postgresql-x.y.z/contrib called oracle that
has some helpful scripts.




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Mon, 2004-10-25 at 09:16 -0500, Vassilev, Lubomir G. wrote:
It is part of the tarball that you download (if you download the
source).

--
Oliver Elphick olly (AT) lfix (DOT) co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Only take heed to thyself, and keep thy soul
diligently, lest thou forget the things which thine
eyes have seen, and lest they depart from thy heart
all the days of thy life; but teach them to thy sons,
and to thy sons' sons..." Deuteronomy 4:9


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org