I am using IntelliJ and its database plugin to export data from a table on one database to a table on another database.
The tool works brilliantly, but I need to perform this task repeatedly.
Is there a way I can automate this so that it runs according some some schedule, of say, once a day?
I'm happy to code this up in Python, but I don't want to have to re-invent the tool.