Avatar of sidwelle
sidwelleFlag for United States of America

asked on 

moving files from linux to windows SQL

I have a project where I need to move files from a Linux file system to a Microsoft SQL server.

The app that I have resides on a Linux server and allows for older data records to be purged in form of small files. (1kb each)
I need to get these files to the windows server to allow a script (SSIS or other) to read the files and import them into SQL.

This routine will be run nightly, so the thought of a backup or anything else the requires a lot of intervention is not practical.

What's the best way to get this done ?  

   1.   If I have SAMBA loaded on the Linux server, I could easily read the files from a folder share ?
   2.   I could use [s]FTP to move the files from one system to the other ?
   3.   Write a script to run on the Linux system to read the files and insert them directly to SQL server via ODBC ?
   4.   Any other options ?

Thank you.
LinuxWindows OSMicrosoft SQL Server

Avatar of undefined
Last Comment
David Favor
ASKER CERTIFIED SOLUTION
Avatar of David Favor
David Favor
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of David Favor
David Favor
Flag of United States of America image

Marking my answer as a solution, as it describes various ways to accomplish what poster asked.

Poster never posted an update.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo