Re: postgresql to Oracle database migration

Hi All,

nice question, there are many company that can do a professional support if
you need.

Thanks
Pier

Il giorno gio 9 mar 2023 alle ore 18:49 Jwiencek3 <jwiencek3(at)comcast(dot)net>
ha scritto:

> The curious side of me would like to know what made you decide to migrate
> from postgresql to oracle? Seems the trend now-a-days is the reverse. Do
> you have a really large budget you need to eat up?
>
> Sent from my iPad
>
> On Mar 9, 2023, at 7:09 AM, Sumit Sengupta <ssengupta(at)hotmail(dot)com> wrote:
>
> 
> Also Oracle considers zero byte character space as Null although they
> recommend not to assume it will stay that way. Here is a short blog
> <https://www.linkedin.com/pulse/null-value-differences-rdbms-sumit-sengupta>
> comparing Oracle, Postges, MySQL and SQL Server around Nulls.
>
>
> ------------------------------
> *From:* Holger Jakobs
> *Sent:* Thursday, March 9, 2023 4:48 AM
> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org
> *Subject:* Re: postgresql to Oracle database migration
>
>
> Am 09.03.23 um 10:46 schrieb Renjith Gk:
> > Hi,
> >
> > Can anyone confirm any online tool or best practice to migrate
> > postgresql queries to Oracle, there are few syntax differences
> > compared from postgresql to Oracle
> >
> > Best regards,
> > Renjith
>
> There is no easy solution because Postgres' SQL dialect is a lot richer
> than Oracle's.
>
> Most trivial queries will work immediately.
>
> Kind regards,
>
> Holger
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>