Best way to sync dbs

I have a Magento db and postgres db for the app I am running. I want to sync data changes occuring in my Magento db for a particular table to be migarted to my postgres db each day.Wat I want to do is run a cron job every day and update postgres with latest increments changes.For that I want to use a AWS lambda to trigger a node js script which will use typeorm to connect to two dbs .it fetches from magento db in a single go and opens the postgres connection and writes to it.How should I modify this to be production quality? Is there a way to do it in batches or make it more reliable or fault tolerant or any good node js handling practices?PS: I dnt wanna use any queueus or messaging system

Submitted July 29, 2020 at 08:48PM by MardGreer93