Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to correctly migrate from Firebird 2.5.1 to Firebird 3.0?

I'am trying to migrate Firebird 2.5.1 to Firebird 3.0 What is done:

  1. Back up on Firebird 2.5.1
  2. Restore on Firebird 3

The problem is that not all tables were migrated; procedures, triggers and views are not recovered.

Why? Is anywhere manual how to migrate correctly?

like image 381
May12 Avatar asked Nov 02 '25 00:11

May12


1 Answers

In my case, I backed with gbak in Firebird 2.5 and then restored in Firebird 3 with -FIX_FSS_METADATA UTF8

gbak -c -v -user SYSDBA -password thepass /home/lbonomo/ssp.fdb.t.bk  localhost:ssp -FIX_FSS_METADATA UTF8
like image 142
Lucas Bonomo Avatar answered Nov 03 '25 15:11

Lucas Bonomo