Jump to content

Recommended Posts

Posted

I migrated Firebird database from 2.5 to 5.0  without any problem:

Do a Backup / Restore  like this  :

1. Save your DB (Backup with old gbak) in Firebird 3.0

2. Uninstall the old Firebird 3.0

3. Delete all Firebird Folders :

• C:\ProgramData\Firebird

• C:\ProgramFiles (x86)\Firebird

• And also C:\windows\syswow\Fbclient.dll

4. Install your new Firebird 5.0

5. Restore your DB With the new gbak

That'all.

Posted

There are some Issues from a big list:

  •  UDF issues
  •  CURRENT_TIMESTAMP and CURRENT_TIME have time zone
  • sweep is not auto if a transaction is COMMITTED READ CONSISTENCY

...

 

Posted
36 minutes ago, AlexM123 said:

There are some Issues from a big list:

  •  UDF issues
  •  CURRENT_TIMESTAMP and CURRENT_TIME have time zone
  • sweep is not auto if a transaction is COMMITTED READ CONSISTENCY

...

 

Humm... I see.

"Alternatively, create the new database structure on Firebird 5.0, and pump the data from the old Firebird 2.5 database to the new Firebird 5.0 database."

Mark Rotteveel

Posted
On 4/22/2026 at 12:16 PM, AlexM123 said:

But a lot of work to migrate data from 3 to 5

FB 6 will realese :) if you wanna upgrade, investigate fb6 and then move new structure  on fb 6. Table data transfer is not too hard. many tools has it.

 

Firebird roadmap

 

  • Thanks 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...