Transferring data from postgres to mysql using cron?

Question

MySQL

As I understand it, you can write a query directly in cron, or you can use python and create a file to run.
Which path is the most correct?

Answer 1

I write bash scripts that cron runs

Answer 2

Both paths are good. Everything depends on your requirements.

Answer 3

Maybe www.enterprisedb.com/postgres-plus-edb-blog/dave-p...
www.enterprisedb.com/postgres-plus-edb-blog/ahsan-...