Subject | gbak: firebird => interbase, sql dialect 1 |
---|---|
Author | Martin.Rasp@ptb.de |
Post date | 2003-06-11T09:08:41Z |
Hi.
I made a backup of a firebird database (has been created with SQL dialect
1) and created a new interbase database of the backup archive as source.
The problem is that our CMS software 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]
I made a backup of a firebird database (has been created with SQL dialect
1) and created a new interbase database of the backup archive as source.
The problem is that our CMS software 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]