Записи за June, 2016
How to query MS SQL Server database from Linux CLI
Wednesday, June 15th, 2016
We have no need of other worlds. We need mirrors. We don't know what to do with other worlds.
Stanisław Lem «Solaris»
So let's assume that we need a small keyhole to look into SQL Server database and query some data from it. Maybe we'd like to automate some reporting stuff or to make some web GUI with some information stored in MSSQL. And of course we don't want to deal with Windows.
Fortunately there is such a project as FreeTDS. It gives us a driver for using with ODBC engine. I will show how to configure it and how to retreive some data right from MSSQL.
Everything written below is true for the case of RHEL/CentOS 7.
Метки: Linux
Категория: Linux | Нет комментариев »