On 05/01/2020 15:55, John M buff...@gmail.com [firebird-support] wrote: >> > My DB is very small at < 200MB. Is it better to upgrade to FB 2.5.9 >> > before the win upgrade? If so, what is the best way to do this upgrade? >> > >> > I have spent several hours already googling answers, but none I find >> > seem to give me a clear path. >> >> Upgrading Windows is not really related to upgrading Firebird, which is >> probably why you can't find a clear path by Googling for it. If you had >> kept up-to-date with Firebird 2.5 updates, this question wouldn't even >> have come up. >> >> I would recommend upgrading Firebird before the update, then if any >> problems arise during the Windows upgrade, you know they are not related >> to the Firebird upgrade. You could also do the reverse, but as 2.5.2 was >> built long before Windows 10 even existed, it is better to upgrade to >> 2.5.9 first. >> > ON this point. I didn't find FB upgrade instructions. When I did a > test upgrade of just FB on a Win 10 computer from 2.5.3 to 2.5.9, I > didn't see an "upgrade" option. Should I assume I need to uninstall FB > 2.5.2 and then install FB 2.5.9?
Normally, between point releases, uninstalling the old version and installing the new version is sufficient, because the on-disk structure (ODS) is the same between those versions. However, some of the older versions of 2.5 had issues with indexes that require an index rebuild to fix, and backing up and restoring the database is the way to do that. >> When upgrading Firebird 2.5.2 to Firebird 2.5.9, it is probably a good >> idea to use backup and restore, especially when your database was >> created with 2.5.1. >> > I'm pretty sure I switched from IB to FB using 2.5.2. If so, would > this step be necessary? Is there a way to check the DB version? The problem in the earlier 2.5 versions is with the same database version, so checking the database version will not provide sufficient information. However for sake of completeness, you can check the ODS version using: gstat -h <path to database> ODS 11.2 means it is a Firebird 2.5 database. Mark -- Mark Rotteveel
