Martin,
I think this question was answered the first time you asked it...

Try using

gfix -sql_dialect 1

on the database _before_ doing the backup. Don't forget to reset it
afterwards!

[Paul Reeves]

Also - what CMS are you using?

Alan

> -----Original Message-----
> From: Martin.Rasp@... [mailto:Martin.Rasp@...]
> Sent: Thursday, 12 June 2003 4:48 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] gbak: firebird => interbase, sql dialect 1
>
>
> 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]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>