pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedData sync between Oracle Non Cloud and PostgresDb in Azure
4+ messages / 3 participants
[nested] [flat]
* Data sync between Oracle Non Cloud and PostgresDb in Azure
@ 2020-08-11 23:00 Jay Korrapati <jaykorrapati@outlook.com>
2020-08-12 00:17 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure David <dbwagoner@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Jay Korrapati @ 2020-08-11 23:00 UTC (permalink / raw)
To: ; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
Thanks and Best Regards,
Jay Korrapati,
Software Application Engineer,
Cell No: 720-336-3660
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
2020-08-11 23:00 Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
@ 2020-08-12 00:17 ` David <dbwagoner@gmail.com>
2020-08-18 23:52 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
0 siblings, 1 reply; 4+ messages in thread
From: David @ 2020-08-12 00:17 UTC (permalink / raw)
To: Jay Korrapati <jaykorrapati@outlook.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Jay,
Have you checked out the Azure Database Migration Service?
https://azure.microsoft.com/en-us/services/database-migration/
Best wishes,
David
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
2020-08-11 23:00 Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
2020-08-12 00:17 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure David <dbwagoner@gmail.com>
@ 2020-08-18 23:52 ` Jay Korrapati <jaykorrapati@outlook.com>
2020-08-19 05:55 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: Jay Korrapati @ 2020-08-18 23:52 UTC (permalink / raw)
To: David <dbwagoner@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
Jay,
Have you checked out the Azure Database Migration Service?
https://azure.microsoft.com/en-us/services/database-migration/<https://nam11.safelinks.protection...;
Best wishes,
David
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Data sync between Oracle Non Cloud and PostgresDb in Azure
2020-08-11 23:00 Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
2020-08-12 00:17 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure David <dbwagoner@gmail.com>
2020-08-18 23:52 ` Re: Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
@ 2020-08-19 05:55 ` Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2020-08-19 05:55 UTC (permalink / raw)
To: Jay Korrapati <jaykorrapati@outlook.com>; David <dbwagoner@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-08-19 05:55 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-11 23:00 Data sync between Oracle Non Cloud and PostgresDb in Azure Jay Korrapati <jaykorrapati@outlook.com>
2020-08-12 00:17 ` David <dbwagoner@gmail.com>
2020-08-18 23:52 ` Jay Korrapati <jaykorrapati@outlook.com>
2020-08-19 05:55 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox