This can be done using a Windows task, and WinSCP.
First, go and install WinSCP http://winscp.net/eng/index.php
Once that is installed, click New, then enter the information for your server. If you are using keys, locate the key files, otherwise enter the password. Click save. In the dialog that comes up, be sure to check "Save password" if you aren't using key files. Remember the profile name that you chose.
Next Create a file, config.txt
in the same location you installed WinSCP
in the file insert the following, replacing the ** with things specific to you.
option batch on
option confirm off
open *NAME OF PROFILE* synchronize local -mirror *Local path: \\servername\location\common* *Remote Path*
exit
Press Windows Key + R
Then type taskschd.msc /s
click okay. In the right hand side of the window that opens select Create Task...
Enter a Name: Folder Auto Upload
(or whatever suits you)
Click on the Triggers
tab then click New
Select the Daily
radio button There will be a time listed, Adjust the time to when you want the upload to happen. Click OK
Click on the Actions
tab click New
in the Program/script field enter the location of the WinSCP.exe (or browse to where you installed it and select it.) in the Add arguments (optional): field enter /console /script=config.txt
then click OK
click OK
again, and you should be all set.
Transfer how? FTP, SMB...? – m0skit0 – 2012-02-08T09:58:13.797
@m0skit0 - that is part of the question, I'm open to optinos. – toop – 2012-02-08T10:20:29.500
Are the files text or binary? – m0skit0 – 2012-02-08T10:40:53.853
text (i believe ascii win format with crlf linebreaks) – toop – 2012-02-08T11:20:38.747
Are they the same files that change content or totally new different files? – m0skit0 – 2012-02-08T15:01:45.003
@m0skit0 - they could be either, likely different files. The intention is not to do a backup but instead to execute some SQL contained in the files through sqlplus. – toop – 2012-02-09T09:18:14.950
@m0skit0 - bounty up for grabs if you can provide more detail and a recommendation. – toop – 2012-03-11T08:11:00.027