Обсуждение: Data sync between Oracle Non Cloud and PostgresDb in Azure
Hi All,
I am looking for solutions where we can get live data from syncing data from Oracle in on premises to PostgresDB in Azure cloud.
I am thinking of having both PostgresDB on a VM in Azure could and Managed PostgresDB.
Your inputs are very helpful.
Jay Korrapati,
Software Application Engineer,
Cell No: 720-336-3660
Jay,
Have you checked out the Azure Database Migration Service?
Hi David,
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.
Thank you,
Jay Korrapati.
Thanks and Best Regards,
Jay Korrapati,
Software Application Engineer,
Cell No: 720-336-3660
From: David <dbwagoner@gmail.com>
Sent: Tuesday, August 11, 2020 6:17:28 PM
To: Jay Korrapati <jaykorrapati@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
Sent: Tuesday, August 11, 2020 6:17:28 PM
To: Jay Korrapati <jaykorrapati@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
Jay,
Have you checked out the Azure Database Migration Service?
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