Art of BI: Migrating files using SCP on Linux or Unix

By | In Art of BI, Big Data, Business Intelligence | April 28th, 2016

Here’s a short blog post as a quick reference for some of the ways to move files using the terminal window for Linux/Unix using the SCP cmd. For this example we will be moving files and directories from a Dev environment onto a TST environment.

As an example, let’s walk through how to copy the file nohup.log from the ./start_stop directory in DEV to a directory into TST:

– Be sure to add a forward slash for the target folder because if not it may interpret it as the name of a file that you are writing to.

– You will be asked to enter the password of the TST (Going to) userName from the system. This will not run if the password is incorrect.

To copy all files with the same file type .py from the start_stop directory from DEV to a directory in TST:

– You will be asked to enter the password of the DEV (Source) userName from the system. This will not run if the password is incorrect.

To copy the entire directory start_stop from Dev to a directory in TST:

– You will be asked to enter the password of the DEV (Source) userName from the system. This will not run if the password is incorrect.

– The key here is to use the “-r” switch for copying an entire folder directory

In the end, one should always use the “man” command, for example “scp man”, from the terminal prompt to get all the information about the programs on which they have questions.

Contact Us
Bill brings 6 years of technology implementation and team management experience to Datavail’s services and delivery team. Primarily focused on the Oracle Analytics and Hyperion ecosystem, he has a proven ability to integrate disparate heterogeneous data sources using a number of Oracle analytical reporting platforms. He has led multiple projects developing moderate to complex solutions in industries such as financial services, manufacturing, and the Public Sector. In addition to being a seasoned Oracle BI and Hyperion Essbase developer, he is also a course instructor for a number of Datavail’s OBIEE training courses.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).