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
