|
From: info <in...@dr...> - 2023-08-30 15:24:14
|
Is Squirrel really necessary for running batch files? The DB server's CLI should be able to do it. Squirrel is an IDE. On 2023-08-30 09:44 AM, Stanimir Stamenkov via Squirrel-sql-users wrote: > Wed, 30 Aug 2023 11:41:11 +0200 (CEST), /Stepan/: > >> Now I have problem. I have a SQL several files each one with about >> 6.000 SQL commands. I need to run each file against one database from >> time to time. But when I open this file, SQuirreL hangs for several >> minutes. Is there any nice workaround in GUI of SQuirreL? I guess >> something like run SQL from file without opening in TextArea, bypass >> checking of SQL... > > Haven't used it myself but I'm aware there's a Command Line Interface > (since v3.9.0) [1]: > >> See Readme.txt in the squirrelcli/ subdirectory of your SQuirreL >> installation. > > The "Readme.txt" [2] says: > >> The squirrelcli* scripts offers two modes: >> 1. The batch mode which, as mentioned above, you can learn about by >> entering squirrelcli* -help on your command line. >> 2. The Java JShell based mode which can be entered by executing the >> script with no parameter (or -userdir only). This requires JDK (not >> JRE) as JShell is only available in JDKs. > [1] > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/core/doc/changes.txt#L1917-L1918 > [2] > https://github.com/squirrel-sql-client/squirrel-sql-code/blob/ca6c285/sql12/launcher/squirrelcli/Readme.txt > |
