CODEWITHSUNDEEP
command-lineftpfilesize
Asha
Asha

Reputation: 4311

compare file size after ftp get with the original file on server

In SQL I'm using xp_cmdShell to run FTP commands. I have no problem getting the list of files or copying files to the local server, but I want to compare copied file size to the original to make sure the get has been successful.

Any ideas on how to compare file sizes?

Upvotes: 0

Views: 5648

Answers (1)

Shiv Kumar
Shiv Kumar

Reputation: 9799

From a command prompt you can use the DOS File Compare command (fc). In your case you probably want to do a binary compare (there is no file size compare). I binary compare should work in your case.

Most DOS commands will return some code that let s you know the status.

http://www.computerhope.com/fchlp.htm

EDIT Sorry, I read your question and realized you want to compare it against a file on the ftp server. I think this is a moot point since if ftp reports a successful file transfer there is no reason to compare (unless your source of comparison for not the ftp site). Does that make sense?

What you could do it use the FTP command ls command. 

ftp> ls <filename>

where ftp> is the ftp prompt and not part of the command. This command gives you the file size in bytes. Then you need to use the dos command for the local file. Here is a StackOverflow question (and answer) about that. Windows command for file size only?

Upvotes: 1

Related Questions