Hi: My problem is that I want to append data from a dbf file to a mysql table automatically every night.
My question is twofold, of course - how to append and how to schedule - but one at a time I think!
The question is this:
what would the experts propose to be the program best suited for running on a schedule?
I am looking at Ruby, but would also consider Java, python, or anything else. I guess I will wrap a SQL command into the program which will be executable from a cron?
Before I start down one path I would like to know that whatever I use can be scheduled to run on a debian server nightly. And a little pointer as to how best to achieve that would be most beneficial!
Sorry to be so general but thanks anyway!