How to "move" database from Firebird 5 to Firebird 3

[Marcin Bury]

Hi

I have Firebird 5 database (on Windows) that I'd like to backup and then
restore it in Firebird 3 running on Linux.
Standard gbak backup/restore procedure does not work since new version
of backup file in FB5.
So how could I backup this FB5 database to be able to restore it in FB3?

TIA
Marcin

[Mark Rotteveel]

You could try to back it up with a Firebird 3 gbak (*not* Firebird 5
gbak) and then restore it, but IIRC, that is not guaranteed to work. The
better way is probably to recreate the database and pump the data from
the Firebird 5 to Firebird 3 database.

Mark
--
Mark Rotteveel

[Marcin Bury]

I have tried - the first thing after failure.
Unfortunately it said it only supports ODS 12.2 and found 13.1 :-(

Marcin

------ Wiadomość oryginalna ------
Od: "'Mark Rotteveel' via firebird-support"
<firebird...@googlegroups.com>
Do: firebird...@googlegroups.com
Data: 15.02.2025 14:32:32
Temat: Re: [firebird-support] How to "move" database from Firebird 5 to

Firebird 3

>On 15/02/2025 14:30, Marcin Bury wrote:
>>I have Firebird 5 database (on Windows) that I'd like to backup and then restore it in Firebird 3 running on Linux.
>>Standard gbak backup/restore procedure does not work since new version of backup file in FB5.
>>So how could I backup this FB5 database to be able to restore it in FB3?
>
>You could try to back it up with a Firebird 3 gbak (*not* Firebird 5 gbak) and then restore it, but IIRC, that is not guaranteed to work. The better way is probably to recreate the database and pump the data from the Firebird 5 to Firebird 3 database.
>
>Mark
>-- Mark Rotteveel
>

>-- Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
>https://www.firebirdsql.org/donate
>--- You received this message because you are subscribed to the Google Groups "firebird-support" group.
>To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
>To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/b55713a1-bdb6-491c-bcb0-9d3c383df91a%40lawinegevaar.nl.

[Mark Rotteveel]

On 15/02/2025 14:40, Marcin Bury wrote:
> I have tried - the first thing after failure.
> Unfortunately it said it only supports ODS 12.2 and found 13.1 :-(

You need to connect through the server, not directly to the file.

Mark
--
Mark Rotteveel

[Mark Rotteveel]

On 15/02/2025 14:40, 'Mark Rotteveel' via firebird-support wrote:
> On 15/02/2025 14:40, Marcin Bury wrote:
>> I have tried - the first thing after failure.
>> Unfortunately it said it only supports ODS 12.2 and found 13.1 :-(
>
> You need to connect through the server, not directly to the file.

That is use <servername>[/<port>]:<filename> instead of just <filename>
**do not** use the service manager option.

Mark
--
Mark Rotteveel

[Marcin Bury]

Gbak from FB3 has managed to create a backup of FB5 database, but
restore process exited with error

gbak: ERROR:Error while parsing procedure SP_OPERATION_COMPLETED's BLR
gbak: ERROR: invalid request BLR at offset 549
gbak: ERROR: BLR syntax error: expected valid BLR code at offset 550,
encountered 64
gbak:Exiting before completion due to errors

So it looks like there is no "rather" simple way to port FB5 db to
FB3...

Marcin

------ Wiadomość oryginalna ------
Od: "'Mark Rotteveel' via firebird-support"
<firebird...@googlegroups.com>
Do: firebird...@googlegroups.com

Data: 15.02.2025 14:44:59

Temat: Re: [firebird-support] How to "move" database from Firebird 5 to
Firebird 3

>-- Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
>https://www.firebirdsql.org/donate
>--- You received this message because you are subscribed to the Google Groups "firebird-support" group.
>To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

>To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/3ee424e0-8bb9-409e-9678-bc582beaaaff%40lawinegevaar.nl.

[Mark Rotteveel]

On 15/02/2025 14:51, Marcin Bury wrote:
> Gbak from FB3 has managed to create a backup of FB5 database, but
> restore process exited with error
>
> gbak: ERROR:Error while parsing procedure SP_OPERATION_COMPLETED's BLR
> gbak: ERROR:    invalid request BLR at offset 549
> gbak: ERROR:    BLR syntax error: expected valid BLR code at offset 550,
> encountered 64
> gbak:Exiting before completion due to errors
>
> So it looks like there is no "rather" simple way to port FB5 db to FB3...

That is probably a stored procedure that was created or recompiled under
Firebird 5. You could try dropping it and trying again, but it would be
playing whack-a-mole that way.

Mark
--
Mark Rotteveel

[Marcin Bury]

If the reason is that procedure was recompiled under FB5, so there are
quite a few that I touched :-)
Thanks, Mark, anyway, you are always "on duty", duly respected...

------ Wiadomość oryginalna ------
Od: "'Mark Rotteveel' via firebird-support"
<firebird...@googlegroups.com>
Do: firebird...@googlegroups.com

Data: 15.02.2025 15:20:08

Temat: Re: [firebird-support] How to "move" database from Firebird 5 to
Firebird 3

>-- Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
>https://www.firebirdsql.org/donate
>--- You received this message because you are subscribed to the Google Groups "firebird-support" group.
>To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

>To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/e0967736-7898-42df-93bd-a8552c79807f%40lawinegevaar.nl.