4

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?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
May12
  • 2,420
  • 12
  • 63
  • 99
  • 2
    Backup and restore should work. If not, you might want to consider posting a bug on http://tracker.firebirdsql.org/browse/CORE. What commandline options did you use for backup and restore? Were there any errors in the output of either backup or restore? Are you sure you used the appropriate gbak version (the 2.5 version for backup and the 3.0 version for restore)? Have you also checked what happens if you backup and restore under 2.5.1 (or from 2.5.1 to - for example - 2.5.5). If all else fails, recreate the database structure and pump the data. – Mark Rotteveel May 18 '16 at 13:06
  • 1
    Maybe this will help http://www.firebirdnews.org/migration-guide-to-firebird-3/. Unfortunately it is not free. Yesterday I received the link an e-mail. – Val Marinov May 18 '16 at 14:09
  • 1
    can you use ibeexpert, load sheme and all data to dml`s format on firebird 2.5 then using firebird 3.0 reconstruct your db? – AlexBee Mar 29 '18 at 04:49

1 Answers1

2

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
Lucas Bonomo
  • 21
  • 2