How to do?
Usage: sqla -t <DBMS type> OPTIONS from command line. Or startup from SQL*All - Windows GUI. Below lists the command line OPTIONS:
| Short | Long | Description |
|---|---|---|
| -? | --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. (Upper-case 'P') |
| --prompt | Set SQL*All prompt. | |
| -t | --type | DBMS type. |
| -u | --user | User for login. |
Notice: all parameters are case sensitive.
e.g.: sqla -tmssql -hlocalhost -P1433 -usa -p12345 -dpubs (or sqla --type=mssql --host=localhost --port=1433 --user=sa --password=12345 --database=pubs) meaning connect to MSSQL database pubs which located in localhost, listenning port is 1433 by user(sa) with password(12345).
Run Commands/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.