SQLTool is a command line tool to execute sql commands. It may be used to import/export
files into a database.
Copy sqltool.rc file in the sample folder into the data folder.
Open the data and edit the runUtil.bat file.
Right click on the runUtil.bat file and select Edit.
Insert -jar argument and --rcfile sqltool.rc localhost-sa argument.
Save the changes.
Select File - Save As... from the menu.
Save the script file as runSqltool.bat in the data folder.
In the Save in:, select the data folder.
In the File name:, enter runSqltool.bat. [
Select the Save button to save the changes.
Let's execute the script file we just created.
From the File Explorer, double click on the runSqltool.bat file.
A MS DOS command prompt window will open and SQLTool should start.
If all goes well, there should be a sql prompt.
Let's shutdown the HSQL server from SQLTool.
Enter shutdown; and press on the Enter key.
To exit SQLTool, enter \q and press on the Enter key.
