Source and destination file are different from SFTP transfer

1143040 pts.
Tags:
File transfer
SFTP
Hopefully I can explain this clearly. We transferred a file from one server (source file) to our other server (destination file) using SFTP. But now we're seeing a file integrity issue - meaning that the sizes from the source file and destination file are different. How can that be? Same exact file system.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

It is possible and can happen depending on the file structure set by the OS. It can be different depending on a number of factors. Mainframes and mid range computer had blocking factors for the files. Never checked this out but if one file has a lot of deleted records I don’t know if the FTP only sends active records. If the systems are running different OS that would be my first guess. Provide some additional info and we can try and help straighten this out. Also just to make sure you have all the data, check out the record count on both systems to make sure all the data did copy over correctly. 

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    What OS is there like what OS is source side and what OS is other side? Is the both OS are same or different? If one OS is Windows and other side OS is Linus/ Mac type, then some differences may be occurred due to their ratio between file size in Windows text file format and Linux/Mac text file format.
    139,010 pointsBadges:
    report
  • TheRealRaven
    It can happen easily and should be an expected possibility. Source database file might contain ten active rows while having space that no longer holds 100 previously deleted rows. Destination database file may have allocated space for only the ten rows. Various characteristics can result in differing space allocations. Dependencies can exist in differing OS versions, differing fix levels of file systems and who knows what else. Anything that changes in determining where an end-of-file marker is generated can result in a "size" difference.
    35,210 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: