Subject Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3
Author Mark Rotteveel
On 13-2-2019 18:29, Kevin Stanton Kevin.Stanton@...
[firebird-support] wrote:
> Thanks Mark. I realize it’s a huge migration. I will be exhaustively testing everything. I like the idea of creating an empty database and pumping the data over. Is there a tool for this? (Actually just found one from Clever Components)

There are a number of Firebird-specific tools, see for example
https://www.ibphoenix.com/download/tools/migration

But at times I just resort to writing such things in code or using an
ETL tool (especially if it isn't between the same structure, or if data
needs some additional transformations).

> I have looked at the migration docs for the 2.x versions and will do more.
>
> Do you think it’s worth me going to 2.5 first or go directly to 3.0? Both will be a ton of work so I’m thinking directly to 3.0.

I'd suggest going to Firebird 3 directly. I'd almost suggest trying to
go for Firebird 4, but as it is still in development that is probably
not the best idea.

Mark
--
Mark Rotteveel