On 13-2-2019 18:29, Kevin Stanton kevin.stan...@rdb-solutions.com [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