How do I create a new Firebird database from the command line?

dthrasher picture dthrasher · Oct 21, 2009 · Viewed 12.4k times · Source

I'd like to create a new Firebird database in my C# client application. Is there a command line utility that lets you do this?

Answer

Hugues Van Landeghem picture Hugues Van Landeghem · Oct 21, 2009

you can use isql but I advice you to use directly the api.

isql -input test.sql

test.sql is like this :

SET SQL DIALECT 3;

SET NAMES UNICODE_FSS;

CREATE DATABASE 'D:\testdata.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UNICODE_FSS;

CREATE TABLE CUSTOMERS (
    CUST_ID       INTEGER NOT NULL,
    CUST_NAME     INTEGER,
    CUST_UNISITE  INTEGER
);

CREATE TABLE SMS_DETAIL (
    SD_ID                       INTEGER NOT NULL,
    SD_MESSAGE_DATA             VARCHAR(160)
);

creating database via the api