Atikh's DBA blog
  • Home
  • Oracle
  • MySQL
  • MongoDB
  • PostgreSQL
  • Snowflake
  • About Me
  • Contact Us

Transferring file from one server to another server [FTP, SFTP, SCP etc]

 Atikh Shaikh     MongoDB, mysql, oracle, Oracle 12c, PostgreSQL     No comments   

There are number of ways to transfer file from one server to another server, below are the few methods to to achieve the same

  1. ftp
  2. sftp
  3. scp
  4. windows software (Filehippo, WinScp , FileZilla etc)
We will discuss these in details

1. FTP transfer

File Transfer Protocols basically is set of rules on computer network to communicate with one another. This FTP tool or utility can be used to transfer files from one server to another server.
Below are the commands to use ftp
$ftp
User : 
Password :
ftp> bin  -- to transfer in binary format
ftp> cd
ftp> put/get -- put for sending from one server to another and get is vice versa
ftp>bye


2. SFTP transfer

As name suggest SFTP is secure file transfer protocol, it uses full security and authentication functionality of SSH. SFTP is new utility compared to FTP and recommended to use instead of FTP
This utility can be used using below commands
$sftp @
password : ***
sftp>cd
sftp> put/get -- put for sending from one server to another and get is vice versa
sftp> bye


3.SCP 

SCP is used for securely copying files from one server system to another server system. 
Below is syntax for the same

scp [OPTION] [user@]src_server:] file1 [user@]target_server:]file2
where 
[user@]src_server:] file1 -- source file
[user@]target_server:]file2 -- destination file

for example
scp text_file.txt  @:/


4. Windows software

There are number of freely available software on internet, choose your favourite one and transfer files using simple GUI
Below are few I came across

  • FileZilla
  • Filehippo
  • WinScp
  • FireFTP

Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Instagram
  •  Pin
  •  linkedin
  •  reddit
Newer Posts Older Posts Home

Author

Atikh Shaikh
View my complete profile

Categories

  • MongoDB (18)
  • Oracle 12c (30)
  • Oracle12cR2 New Feature (3)
  • PostgreSQL (21)
  • RMAN (10)
  • Snowflake (8)
  • mysql (23)
  • oracle (75)

Blog Archive

  • ►  2018 (38)
    • ►  November (25)
    • ►  December (13)
  • ►  2019 (33)
    • ►  January (15)
    • ►  February (6)
    • ►  March (2)
    • ►  April (5)
    • ►  May (5)
  • ▼  2020 (5)
    • ▼  April (1)
      • Transferring file from one server to another serve...
    • ►  May (2)
    • ►  July (2)
  • ►  2021 (8)
    • ►  June (3)
    • ►  July (3)
    • ►  August (1)
    • ►  December (1)
  • ►  2022 (33)
    • ►  May (3)
    • ►  June (10)
    • ►  July (3)
    • ►  August (4)
    • ►  September (8)
    • ►  October (3)
    • ►  November (2)
  • ►  2023 (14)
    • ►  February (1)
    • ►  April (5)
    • ►  May (2)
    • ►  June (1)
    • ►  September (1)
    • ►  October (1)
    • ►  December (3)
  • ►  2024 (5)
    • ►  January (2)
    • ►  March (3)
  • ►  2025 (7)
    • ►  March (1)
    • ►  April (3)
    • ►  May (2)
    • ►  August (1)
  • ►  2026 (3)
    • ►  January (1)
    • ►  May (2)

Popular Posts

  • Oracle AI Database 26ai: Redefining Operational Continuity
    Oracle’s latest release, AI Database 26ai , is built around one clear promise: making enterprise database operations faster, more resilient,...
  • ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
    I was trying to export the schema in my windows PC, it got stuck with below error    C:\Users\shaik\Videos\technodba exp>expdp userid...
  • Oracle DBA Scripts
    Below are some Oracle scripts used in day to day activities note that below script will generate sql statements and then we need to run...
  • Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
    You must have got mail from application team that they are facing below error while performing operations in database Error: Error Code: ...
  • Oracle 23ai : The all new Hybrid Read-Only for pluggable databases (PDBs)
      The latest Oracle database version, Oracle 23ai, introduced a new open mode called Hybrid Read-Only for pluggable databases (PDBs). Local ...

Labels

oracle Oracle 12c mysql PostgreSQL MongoDB oracle 19c Oracle23c oracle19c Orale PDB-CDB oracle12c python AWS Oracle ASM Virtualbox pluggable database storage engine

Pages

  • Disclaimer
  • Privacy Policy

Follow TechnoDBA

Copyright © Atikh's DBA blog | Powered by Blogger