How to correctly migrate from Firebird 2.5.1 to Firebird 3.0?

firebird database-migration firebird2.5 firebird-3.0
May12 picture May12 · May 17, 2016 · Viewed 7.2k times · Source

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?

Answer

Lucas Bonomo picture Lucas Bonomo · Jul 9, 2018

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

Related questions

Generate insert SQL statements from a CSV file

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I've been trying like EMS Data Import …

Read More
Firebird error "username and password are not defined" with Delphi application

I have an application made with Delphi 2006 and Firebird 2.5. For connection a use Interbase components from Delphi. I setting up in design time a TIBDatabase with username, password tc, and work ok, but when i want to run application in …

Read More
Firebird x Windows 7 x gds32.dll error

I have a fdb file (firebird) from a new client (he doesn't know the version). I have tried to use some GUI to access the database, but with no luck. All of them tell that its missing gds32.dll, but …

Read More