Thanks Mark for the good advice. I have made follow-up comments below.
On 1/5/2020 3:31 AM, Mark Rotteveel [email protected]
[firebird-support] wrote:
On 04/01/2020 23:04, John M [email protected] [firebird-support] wrote:
> I'm have an very old app that is using FB 2.5.2 on windows 7. As many
> know we are being compelled to upgrade to win 10. Will the win 10
> upgrade break during this upgrade? If so, what is the best way to avoid
> this issue?
Neither Windows 7 nor Windows 10 is a server OS. Consider whether you
shouldn't use Windows Server (or switch to Linux).
Yes, agreed. The real catch is the app was designed many years ago to
work with IB running locally. I'm a volunteer IT person who learned
enough to move from IB to FB and got this unsupported but mission
crtical app to run better. At this point the app may not even run
properly under Win 7. I'm just trying to eliminate pionts of failure.
> 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?
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?
I also hope you are aware that Firebird 2.5 is end-of-life, so consider
upgrading to Firebird 3 as well (though going from 2.5 to 3 needs to be
planned and tested more thoroughly than upgrading within 2.5.x).
And as always, check the release notes for all changes and fixes between
2.5.2 and 2.5.9:
https://www.firebirdsql.org/file/documentation/release_notes/html/en/2_5/rlsnotes25.html
Mark
--
Mark Rotteveel
Again, Thanks for your time and advice.
John
