Re: moving from oracle to postgresql

fachhoch wrote:
> We are planning on moving to postgresql from oracle due to high oracle cost.
> Our application uses jdbc , hibernate , moving over to postgresql will it be
> lot of changes or should work with minimal changes?
> I am all new to postgresql.Porting jdbc, hibernate app to postgresql from
> oracle how big can be the migration ?please advice.
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/moving-from-oracle-to-postgresql-tp5718547.html
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
>

Seems hibernate should handle most of the transition, but if there are more
native sql queries involved I have found sequences and limit constructs to
be a real pain in Oracle. At least in Oracle10 there is not limit but rather
a ROWNUM. Attached for your email only the differences for that version of
Oracle and PostgreSQL for database data types.

danap.