Subject gbak: firebird => interbase, sql dialect 1
Author Martin.Rasp@ptb.de
Hi.

I made a backup of a firebird database (which has been created with SQL
dialect 1) and created a new interbase database from backup archive. After
that the used CMS software doesn't run properly. The problem is that it
(CM-System) needs SQL dialect 1 and I can't tell gbak to do so.

The first server runs firebirdss_1.0.2.908-1_i386.deb (converted from rpm)
and the second server runs InterBaseSS_LI-V6.0-1.i386.rpm.

The following command was used to create the backup file:
/opt/interbase/bin/gbak -backup -mode read_write -user foo -pas bar
cms.gdb cms.gbk

On the second server I created the database with the following command:
/opt/interbase/bin/gbak -create -mode read_write -user foo -pas bar
cms.gbk cmsnew.gdb

How can I tell interbase's gbak to use SQL dialect 1? In case of emergency
we need to run the firebird database on the second (development) server.
Thanks for any help/hints.

Martin
--
Physikalisch-Technische Bundesanstalt
Referat Q.42
Martin Rasp
Bundesallee 100
D-38116 Braunschweig
Tel: +49-531-592-8428
Fax: +49-531-592-8405

[Non-text portions of this message have been removed]