[SOLVED] BAT script to copy files and run anther bat script?

nibraz · 11-21-2016, 05:18 AM

Hi

I would appreciate if anyone here can help me with this? this is for my work and I am a bit stuck about how to do this.

My team asked me if I can do a bat script to do the following:

1. connect to server from server1 to server2
2. copy 2 files from server 2 to server 1
3. run the bat script from server 1
(bat script then uploads these 2 copied files) this bat script is already done.

Can anyone helpe me how to do 1,2 and 3?

pan64 · 11-21-2016, 05:28 AM

you gave almost no information, so we can hardly give you any help:
what kind of connection is it?
what kind of os is running on server, server1 and server2?
how do you want to transfer your files (over share, ftp, scp, rsync ...)?
...

http://www.linuxquestions.org/questi...gs-4175464257/
http://catb.org/~esr/faqs/smart-questions.html

wpeckham · 11-21-2016, 05:32 AM

Perhaps. Must we guess what operating systems and what kinds of machines are involved? Is there a TCP network connection between the machines? Is there any special software installed that might either interfere or support this operation? What have you researched or tried before posting the question here?

You might browse the information about asking intelligent questions, available on this site.

nibraz · 11-21-2016, 05:46 AM

Quote:

Originally Posted by pan64

you gave almost no information, so we can hardly give you any help:
what kind of connection is it?
what kind of os is running on server, server1 and server2?
how do you want to transfer your files (over share, ftp, scp, rsync ...)?
...

http://www.linuxquestions.org/questi...gs-4175464257/
http://catb.org/~esr/faqs/smart-questions.html

Sorry forgot to add that..

Connection is from a SFTP
All servers are running windows server 2008.
Transfer files over scp/sftp

sample script which only does copy file:

Code:

"\\server\Polling\ToStoresPolling\"
CD "\\server\Polling\ToStoresPolling\FTP"
ftp -i -s:"\\server\Polling\ToStoresPolling\FTP\FTPUploadScript.txt" > \\server2\Polling\ToStoresPolling\FTP\Log.txt

what it needs to do is after copying the files it need to run the bat script on \\server2 that is already there.

pan64 · 11-21-2016, 06:04 AM

here you can find some tips:
http://stackoverflow.com/questions/1...on-a-remote-pc

nibraz · 11-21-2016, 06:10 AM

Hi

We cant use psexec commmand this wont work.

Its for polling only bat scripts works.

nibraz · 11-21-2016, 06:34 AM

Did this test script..

Quote:

set path=c:\WINDOWS\system32

echo Copying started at %date% %time%>>_date_.txt

xcopy C:\Users\HabeebN\Documents\Infrastructure\Scripts C:\Users\HabeebN\Documents\Infrastructure\Test /s /a /d

echo Copying finished at %date% %time%>>_date_.txt

echo Completed Successfully at %date% %time%>>_date_.txt

echo --------------------------------------------------------------------------- >>_date_.txt

CALL "C:\foo.bat"

echo Uploaded Successfully at %date% %time%>>_date_.txt

pause

Its working on my local computer but how can i make it work on the server? when i put in the server path \\servername it stops working..

nibraz · 11-21-2016, 06:38 AM

problem is how do i get it to work with SFTP?

NevemTeve · 11-21-2016, 06:54 AM

You sure this thing is SFTP? I would think it is "File and printer sharing", a part of Microsoft networking,

nibraz · 11-21-2016, 07:22 AM

Quote:

Originally Posted by NevemTeve

You sure this thing is SFTP? I would think it is "File and printer sharing", a part of Microsoft networking,

Yes the company I work at everything is SFTP and SSL etc part of PCI Compliant.

This script works below but only within the same server. Not sure how to edit this to work from
CONNECT SFTP SERVER 1 to SERVER 2
COPY SERVER 2 file to SERVER 1 (SFTP) connection

Code:

set path=c:\WINDOWS\system32

echo Copying started at %date% %time%>>_date_.txt

xcopy \\172.10.10.2\c$\Test\test1.xml \\172.20.10.2\c$\temp /s /a /d

echo Copying finished at %date% %time%>>_date_.txt

echo Completed Successfully at %date% %time%>>_date_.txt

echo --------------------------------------------------------------------------- >>_date_.txt

CALL "\\172.20.10.2\c$\Test\foo.bat"

echo Uploaded Successfully at %date% %time%>>_date_.txt

pause

schneidz · 11-21-2016, 07:45 AM

does windows have an scp command ?:

Code:

which scp

NevemTeve · 11-21-2016, 08:16 AM

In Windows, it's putty you can use as SSH (and scp, sftp) client. Also there is WinScp

nibraz · 11-21-2016, 08:43 AM

Quote:

Originally Posted by schneidz

does windows have an scp command ?:

Code:

which scp

Quote:

'scp' is not recognized as an in
operable program or batch file.

'which' is not recognized as an internal or external command,
operable program or batch file.

this script i am trying to do is for automated polling

michaelk · 11-21-2016, 09:34 AM

You can use xcopy to copy a file to a remote computer. xcopy does use Microsoft file sharing (CIFS)

To copy a file from server1 to server2 via xcopy.

Code:

net use \\server2\shared_folder password /user:domain\username

xcopy file1.txt \\server2\shared_Folder\file1.txt
 
net use "\\server2\Shared_Folder" /delete

By the way sftp and ftps are different protocols.

NevemTeve · 11-21-2016, 09:47 AM

(And SMB/CIFS is a third protocoll