Migrate from firebird 2.5 to 4.0

[Carlos Mazariegos]

Is it possible to migrate a database from firebird 2.5 to 4.0?

Thanks for your support.

Carlos M.

[Mark Rotteveel]

On 27-08-2022 00:51, Carlos Mazariegos wrote:
> Is it possible to migrate a database from firebird 2.5 to 4.0?

In broad strokes, performing a backup database under Firebird 2.5 with
gbak of Firebird 2.5, restore under Firebird 4.0 with gbak of Firebird
4.0 will do the trick.

Mark
--
Mark Rotteveel

[Carlos H. Cantu]

Yes, the simplest way is to do a backup using gbak on FB 2.5 and a restore in FB 4, but there are many things that you should check to avoid bad surprises.

 

I wrote a +200 pages Migration Guide to Firebird 4 eBook that will help you to move to FB 4 avoiding such surprises. More information at https://www.firebirdnews.org/migration-guide-to-firebird-4/

Carlos

www.firebirdnews.org - www.FireBase.com.br

Is it possible to migrate a database from firebird 2.5 to 4.0?

Thanks for your support.

Carlos M.

--
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 on the web, visit https://groups.google.com/d/msgid/firebird-support/4481be42-faa6-456d-8ab3-cce34588528bn%40googlegroups.com.

[Tommi Prami]

We had a few fixes we had to do before we could restore into FB4, some TimeSTamp literals were unsupported in FB4, and some stored procs that did not return anything but had SUSPEND, and a few others, which I don't recall.

Given that most of those changes should have been done ages ago, because we knew those were problem, mainly the SUSPENDs that were not allowed in FB3 either If I recall)

So I would suggest (depending on your process), to first make all those changes in FB2.5x side, and make sure all are good, then migrate into FB4.

So you don't waste too much time on the migration, because at least we could do all those changes in FB2.5 first, without breaking anything.

-Tee-

--