Getting data from shell script to sql server -

Getting data from shell script to sql server -

i have 2 servers - 1 windows server sql server express , 1 linux server. on linux server have shell service waiting new folder. after added checks if it's ok , after should create new record, illustration in table customer should create new customer.

i have first part don´t know how info shell script sql server.

you follow steps below

setup share on windows server accessible linux server have linux script generate csv file of info inserted , force windows server share via smb. write windows batch file or powershell setup scheduled task on whatever interval want iterates on each file in windows directory dropped linux process , calls bcp insert data. move processed files archive directory part of windows batch file.

for documentation on using bcp: http://msdn.microsoft.com/en-us/library/ms162802.aspx

sql sql-server bash shell