Subject Re: [firebird-support] Running an SQL script from the command - line
Author Helen Borrie
At 11:28 AM 13/10/2004 +0200, you wrote:

>Hi everyone,
>I have an SQL script to create and populate a database, that someone has
>sent me that I would like to run from the command line.
>Can anyone tell me how to do it?

Use the -input switch.

First make sure the script has either SET AUTODDL ON or contains all the
required COMMIT statements. Make sure it has the right SET NAMES and SET
SQL DIALECT commands for the database.
Then go to the bin dir where isql is and do:

Win32 SS:
isql d:\mydb.fdb -i d:\pathto\myscript.sql -u db_owner -password meringue

Win32 Classic:
isql localhost:d:\mydb.fdb -i d:\pathto\myscript.sql -u db_owner -password

On LinuxSS, watch case and type the word "isql" as "./isql" (dot-slash, no

./isql localhost:/data/mydb.fdb -i /data/pathto/myscript.sql ...etc.