Tools
SQSH
apt-get install sqsh freetds-bin freetds-common freetds-dev
Edit /etc/freetds/freetds.conf
, and append:
[MyServer]
host = 192.168.1.10
port = 1433
tds version = 8.0
Optionally edit ~/.sqshrc
:
\set username=sa
\set password=password
\set style=vert
Run:
sqsh -S MyServer
sqsh -S {system name/IP}:{port num} -U {username} -P {password}
List of available databases with:
SELECT name FROM master..sysdatabases
go
Build from source:
$export SYBASE=/usr/local/freetds
$ ./configure
$ make
$ su
# make install
# ls -l /usr/local/bin/sqsh
# ls -l /usr/local/bin/sqsh.bin