| From: | ROS Didier <didier(dot)ros(at)edf(dot)fr> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org> |
| Subject: | synchronization between PostgreSQL and Oracle |
| Date: | 2017-10-12 09:13:03 |
| Message-ID: | 28c9e5ed0a81404190611f71faf74903@PCYINTPEXMU001.NEOPROD.EDF.FR |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi
I would like your advice and recommendation about the following infrastructure problem :
What is the best way to optimize synchronization between an instance PostgreSQL on Windows 7 workstation and an Oracle 11gR2 database on linux RHEL ?
Here are more detailed explanations
In our company we have people who collect data in a 9.6 postgresql instance on their workstation that is disconnected from the internet.
In the evening, they connect to the Internet and synchronize the collected data to a remote 11gr2 Oracle database.
What is the best performant way to do this ( Oracle_FDW ?, flat files ?, ...)
Thanks in advance
Best Regards
[cid:image002(dot)png(at)01D3434B(dot)11DE8400]
Didier ROS
DSP/CSP IT-DMA/Solutions Groupe EDF/Expertise Applicative
Expertise SGBD
Mail : didier(dot)ros(at)edf(dot)fr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Otten | 2017-10-12 10:01:40 | Re: synchronization between PostgreSQL and Oracle |
| Previous Message | Scott Marlowe | 2017-10-12 02:25:44 | Re: blocking index creation |