For historical reasons Heroku is where are reporting database is located, which is a direct copy of production from Linode.
I currently run commands locally every day to copy the Linode database from Linode server to local drive and then push it to Heroku. I need to automate this somehow so it runs 'somewhere' every day - but where?
I know about cron jobs etc and also that you can run workers on Heroku, but I really don't know what is the best/recommended way to go about this and would like to see what others recommend.
I tried googling but caot seem to find anything that points me in the right direction - the results are always heroku to heroku copying! Perhaps someone on here knows of some tools/services that might help automate this task?