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

Question

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?

The client application is built in C#. I'll add that to the question. — dthrasher, Oct 21 '09 at 20:09

Hugues Van Landeghem · Accepted Answer · 2009-10-22T20:34:21.770

11

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

edited Oct 22 '09 at 20:34

answered Oct 21 '09 at 16:42

Hugues Van Landeghem

6,755
3
34
59

Thanks for the isql example. How would I use the API? What language is the API written in? – dthrasher Oct 21 '09 at 20:11
the API language is C++. Many components encapsulate the API in different language. I think you can make this with the dotnet provider. – Hugues Van Landeghem Oct 22 '09 at 20:32

score 0 · Answer 2 · edited Jan 08 '17 at 14:42

We are using something like this for keys insensitive. (Firebird 3 >)

isql -input test.sql

SET SQL DIALECT 3;

SQL> create database 'c:\database\test.fdb' page_size 8192 DEFAULT CHARACTER SET UTF8
CON> ;

CREATE TABLE CUSTOMERS (

    CUST_ID       INTEGER NOT NULL,
    CUST_NAME     VARCHAR(20) COLATE UNICODE_CI,
    CUST_UNISITE  INTEGER
);

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

2 Answers2