scheduled movement of data to remote server

I am getting some data via a nightly batch onto a local server. I have to move this data into tables in a remote Oracle database.

My requirement is that the data move from the server to the remote DB can run as a scheduled job.

I am thinking of having the inserts into DB in the batch file itself. Is this a good approach. Or would it be better to run a java file and invoke that?

Any help will be most appreciated. Thanks. Sonal. Received on Thu Apr 19 2007 - 20:04:41 CDT