solidDB Remote Control (solcon) is a console tool for administration. Users with administrator rights can run ADMIN COMMANDs at the command prompt or by executing a script file that contains the commands. With solcon, the ADMIN COMMANDs can be run as part of the solconstartup command line.
Only users with administrator rights can run commands with solcon. Because solcon can only be used to run ADMIN COMMANDs, if solcon is the only tool that is deployed at a production site, administrators cannot accidentally execute SQL statements that change the data.
Note The ADMIN COMMAND 'command_name' syntax is different in solcon and in solidDB SQL Editor (solsql). With solcon, you must specify the command by using the command nameonly, without the prefix ADMIN COMMAND, the single quotation marks, or a semicolon to terminate the command.
Example: solcon
For example, in solcon, you run the ADMIN COMMAND for backup as backup.
soliddb Remote Control to "tcp 1964" Type help for help soliddb - Version 100.0.0.0 Build 2014-11-30 (Windows 64bit MT) soliddb 100.0 Exit by giving command: exit ----------------------------------------------------------------- >backup
Example: solsql
In solsql, you run the ADMIN COMMAND for backup as ADMIN COMMAND "backup";.
solsql: soliddb SQL Editor (teletype) - Version: 100.0.0.0 Build 2014-11-30 Connected to 'tcp 2315'. Execute SQL statements terminated by a semicolon. Exit by giving command: exit; solsql>ADMIN COMMAND 'backup';