Data sync for large dataset between MS SQL & PGSQL databases

Storm posted 6 months ago

Hi folks.

I am wondering what might be the best and most efficient way to keep a data set of roughly 100,000 products in sync between two databases on different servers.

Currently I am pulling the data down via a connection using FreeTDS to connect to the DB and then looping through each record individually and make the necessary updates.

  • Is there a better way to perform this kind of routine. Perhaps a package that maps field data etc?
  • What is the best way to schedule this process etc.
  • How would one deal with deletions.

If anyone can offer any advice that would be greatly appreciated.

Sign in to participate in this thread!

We'd like to thank these amazing companies for supporting us