Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
On 19-12-2018 17:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Although I haven't read it myself, consider buying "Migration Guide to > Firebird 3" by Carlos Cantu, see > https://www.firebirdnews.org/migration-guide-to-firebird-3/ And now I have read it, I can say that I stand by my earlier endorsement: consider by it. Mark -- Mark Rotteveel
Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
Thank you so much for this information. Priceless!
Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
On 19.12.2018 at 17:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Although I haven't read it myself, consider buying "Migration Guide to > Firebird 3" by Carlos Cantu, see > https://www.firebirdnews.org/migration-guide-to-firebird-3/ Just taking the occasion of this topic being discussed, I'd like to mention one thing that might get overlooked but may as well become a real issue in some cases. There's a short note on the firebirdnews.org site https://www.firebirdnews.org/how-to-migrate-existing-users-from-firebird-2-x-to-firebird-3/ saying, that upgrading existing users from 2.x to 3.x will generate a new random password for each user. Is that really the only option? With a few dozens of systems deployed, a few dozens to a few hundreds users each (real FB users), notifying a couple of thousand employees of our customers about new passwords might be a real no-go. That's one of the main reasons we're delaying the upgrade from 2.5 to 3 at our customers' sites. Any suggestions much appreciated. thanks Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__
Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
On 19-12-2018 17:01, my...@techsol.org [firebird-support] wrote: > I have a few older FB databases that will need upgrading to later > versions. They are pretty large, and most have between 500-1,000 stored > procedures. Some contain many tables with millions of rows of data. > This is not likely to be a small undertaking. Although I realize there > are services out there that I can pay to do this, I'd like to do it > myself simply because I have to manage these databases going forward. > > Is there any documentation regarding doing upgrades like this available > for review? This is all on Linux and I realize that this process will > take some time, so I may need interim support for DBs on upgraded Linux > OS versions as I progress through this, but I'd like to be able to plan > out the migration. > > If anyone can point me to any slides, papers, presentations, etc. that > might help with this, it would be greatly appreciated. I suggest to read all release notes since 1.5 on https://www.firebirdsql.org/en/release-notes/ Also read the "Firebird 2 Migration & Installation". Although I haven't read it myself, consider buying "Migration Guide to Firebird 3" by Carlos Cantu, see https://www.firebirdnews.org/migration-guide-to-firebird-3/ Mark -- Mark Rotteveel
RE: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
<> http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf Regards Paul
[firebird-support] Preparing for upgrade from 1.56 to 3 or 4
I have a few older FB databases that will need upgrading to later versions. They are pretty large, and most have between 500-1,000 stored procedures. Some contain many tables with millions of rows of data. This is not likely to be a small undertaking. Although I realize there are services out there that I can pay to do this, I'd like to do it myself simply because I have to manage these databases going forward. Is there any documentation regarding doing upgrades like this available for review? This is all on Linux and I realize that this process will take some time, so I may need interim support for DBs on upgraded Linux OS versions as I progress through this, but I'd like to be able to plan out the migration. If anyone can point me to any slides, papers, presentations, etc. that might help with this, it would be greatly appreciated. Thanks Myles
