[FireBird] 설치 및 데이터베이스 생성

Install
	
1. Registry 등록
(HKLM\Software\Firebird Project\Firebird Server\Instances)

C:\Firebird\bin>instreg.exe install
Firebird has been successfully installed in the registry.

2. NT 서비스 등록

C:\Firebird\bin>instsvc.exe install
Service "Firebird Server - DefaultInstance" successfully created.

※ CS(Classic Server) 인 경우

C:\Firebird\bin>instsvc.exe install -classic
Service "Firebird Server - DefaultInstance" successfully created.

3. Client 라이브러리 설치

fbclient.dll 인스톨

C:\Firebird\bin>instclient.exe i f
FBCLIENT.DLL has been installed to the System directory.

gds32.dll 인스톨

C:\Firebird\bin>instclient i g
GDS32.DLL has been installed to the System directory.

Uninstallation

1. NT 서비스 종료

C:\Firebird\bin>instsvc.exe stop
Service "Firebird Server - DefaultInstance" successfully stopped.

2. NT 서비스 제거

C:\Firebird\bin>instsvc.exe remove
Service "Firebird Server - DefaultInstance" successfully deleted.

3. Registry 정보 제거

C:\Firebird\bin>instreg.exe remove
Firebird has been successfully deleted from the registry.

4. Client 라이브러리 제거

fbclient.dll 제거

C:\Firebird\bin>instclient r f
The FBCLIENT.DLL has been removed from the System directory.

gds32.dll 제거

C:\Firebird\bin>instclient r g
The GDS32.DLL has been removed from the System directory.

접속

C:\Firebird\bin>fbserver.exe -a

C:\Firebird\bin>gsec -user sysdba -password masterkey
GSEC>

Changing the SYSDBA password

C:\Firebird\bin>gsec -user sysdba -pass masterkey -mo sysdba -pw asdf1234

사용자 생성

GSEC> add testuser -pw testpw

사용자 조회

GSEC> di
     user name                      uid   gid     full name
------------------------------------------------------------------------------------------

SYSDBA                              0     0      Sql Server Administrator
TESTUSER                            0     0
GSEC> quit

데이타베이스 생성

C:\Firebird>bin\isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'C:\Firebird\data\test.fdb' user 'TESTUSER' password 'testpw' page_size 8192 default character set UNICODE_FSS;

데이타베이스 접속

C:\Firebird>bin\isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'C:\Firebird\data\test.fdb' user 'TESTUSER' password 'testpw';
Database:  'C:\Firebird\data\test.fdb', User: TESTUSER
SQL>