just curious..which CMS are you using with IB? is it your own or a
proprietary one?
Alan

> -----Original Message-----
> From: Martin.Rasp@... [mailto:Martin.Rasp@...]
> Sent: Wednesday, 11 June 2003 7:09 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] gbak: firebird => interbase, sql dialect 1
>
>
> 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]
>
>
>
> 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/
>
>