Command Line
Usage: sqla -t <database type> 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.