Probably with third party tools this could be achieved, like Symmetric DS [ https://www.symmetricds.org/].  It's useful in two way synchronization also.  You could check whether it suits your requirements.

Hi Ritesh;

  In my past experiences as a DBA , I try & used the DBMS vendors Unload/Re-Load and/or Export/Import utility features to do that. If the DBMS's are from the same vendor - then they might even support an Auto-Sync feature (like in ASE). That would be even better IMHO.

  However, for the PB shop that wants (needs) to perform this through a PB App, I still like PB's great "PipeLine" object to perform this functionality. I have also done this with the PL object 100's of times in the past with pretty much any DBMS combination out there.  Just my $0.02.   ;-)

Regards ... Chris

Hi,

I don't know if things have changed for pb2019 R3, but at the time of R2, this was the situation: Please see:

https://community.appeon.com/index.php/qna/q-a/httpclient-post-methods-and-gzip-compression

I think you might see an improvement in performance (but not sure) if you could send over the data to an API that takes care of the update. Doing the update from the client - like you do now - will probably need more connections to the AWS server. Just try it.

regards