Command Line

Usage: sqla -t <database type> OPTIONS.

Command line OPTIONS
Short Name Long Name Description Requires
? --help Display help and exit.  
-c --command Execute command after connected.  
-d --database Database to use.  
-f --file Execute script file after connected.  
-h --host Connect to host  
-p --password Password to use when connection to server or database.  
-P --port Port number to use for connection.  
  --prompt Set SQL*Any prompt.  
-t --type Server or database type.
-u --user User for login.  

e.g.: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -dpubs (or sqla --type=mssql --host=localhost --port=1433 --user=sa --password=12345 --database=pubs) meets connect to MSSQL database pubs which located in localhost, listenning port is 1433 by user(sa) with password(12345) .

Run commands or SQL Script when startup

e.g: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -c "show databases;exit;" This command will show databases then exit immediately after connected to mssql.

e.g: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -f "c:\script.sql" This command will executes SQL script file "c:\script.sql" automation after connected to mssql.