13 Command line access
Command line usage skill is a necessary skill for the database developers and administrators.
- Production databases may not have necessary GUI tools installed.
- Remote servers, especially for linux servers, GUI tools may not work without additional work, (ssh tunneling etc)
- Some Oracle problems (like startup failures) could only be solved using command line.
13.1 sqlite
13.2 Oracle
Oracle also provides java based more modern command line interface.
13.3 SQL Server
Microsoft provide powershell modules for management of Sql Server.