MS-SQL Database Access from Linux in 3 steps





	1) Install freetds-dev and sqsh
	$ sudo [emerge|aptitude install|yum install|...] freetds-dev sqsh

	2) Configure freetds
	$ cat /etc/freetds/freetds.conf
	[mssqlsrv1]
	host = mssql.sesser.eu
	port = 1433
	tds version = 7.0

	3) Connect to Database
	$ sqsh -Usa -Smssqlsrv1 [-DexampleDB]
	
	1> SELECT * FROM testtab WHERE fieldname LIKE 'testentry%';
	2> \go
	SAMPLEOUTPUT
	1> UPDATE testtab SET fieldname='wtf' WHERE id='0815';
	2> \go

 


by Markus Sesser