[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

How to automate a process to FTP files from windows server to linux server ?

We are using Red Hat Linux5 as a database server for Oracle db for datawarehousing project.
The data for the warehouse will be coming from many users in csv format and stored on a windows server. we need to FTP the csv data files from windows server to linux server (say at the end of every month) so that the oracle warehouse builder can pick up the data from the specified path (on linux server).
this ftp needs to be automated.
0
ngazge
Asked:
ngazge
1 Solution
 
archang3lCommented:
Hello ngazge,

The windows commandline FTP takes a script parameter which allows you to automate your upload.

ftp -s:upload.txt redhat.localdomain

In upload.txt:
USER xxxx
PASS xxxx
CD /upload
BINARY
MPUT *

etc...

You could run this using the default windows sheduler.

Regards,

archang3l
0
 
Richard OlutolaConsultantCommented:
In addition, before the ftp command, don't forget to cd to the location on the windows box where the source file(s) is/are. Then you may want to add PROMPT before MPUT * so that all files are transferred without prompts.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now