Re: Data sync between Oracle Non Cloud and PostgresDb in Azure

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Jay Korrapati <jaykorrapati(at)outlook(dot)com>, David <dbwagoner(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
Date: 2020-08-19 05:55:55
Message-ID: 2d21028c6859fa74da7b887de4dbfd2ff44abdd9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jay Korrapati wrote:
> I checked out this. But this does not get me real-time data from On prem Oracle to Posgres in Azure.
> There is a time delay for data to migrate.

If you want to access live Oracle data in PostgreSQL, you need oracle_fdw.

But you won't be able to get that on a hosted database.

This is one of the many reasons why hosted databases, despite being beneficial
in many ways, are not a good solution for everything.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Watt 2020-08-19 12:35:19 pg96 not running as service
Previous Message Jay Korrapati 2020-08-18 23:52:10 Re: Data sync between Oracle Non Cloud and PostgresDb in Azure