|
From: Stanimir S. <s7...@ne...> - 2023-08-30 14:15:29
|
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 -- Stanimir |
