Itds

A deadly simple SQL server CLI tools just to ease the developer working on Mac or Linux.

Dependency

Install freetds using the package manager of your system.

Mac

$homebrew install freetds

Ubuntu

$sudo apt-get install freetds-dev

Install

$gem install itds

Usage

Help

$itds --help

Command parameters:

$itds -h <hostname> -p <password> -u <username> -d <contained_database> [SQL]

Execute a command

$itds -h <hostname> -d <database> select 1
+---+

+---+
| 1 |
+---+

Cancel a request in interactive mode.

$itds -h <hostname> -d <mydb>
mydb> waitfor delay '00:00:04'
^C
mydb> select * from test
+----+
| id |
+----+
| 10 |
+----+
mydb> ^C
$