I always tend to do back / restores not only in this migration but on a regular basis. I’m maybe a little on the paranoid side. :) I have noticed some extra lines in the restore log for FB3 (this is true even on a completely new FB3 database):
gbak:fixing views dbkey length gbak:updating ownership of packages, procedures and tables gbak:adding missing privileges gbak:fixing system generators gbak:finishing, closing, and going home gbak:adjusting the ONLINE and FORCED WRITES flags The script is very easily generated out of IB Expert. I cannot praise this tool enough. I haven’t tried the script using isql but I would be surprised if it didn’t work. I will give it a shot possibly over this coming weekend. I’m slammed at the moment. I also use FlameRobin for FB1. Not sure if that is compatible with FB3? There were some concerns in previous postings. Cheers, Kevin > On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br > [firebird-support] <firebird-support@yahoogroups.com> wrote: > > Step 1 is better if you are going from dialect 1 to 3, mostly due to > the difference in the numerics internal storage. > > I see no problem with any of the approaches. > > I would add that, imho, step 4 in process 2 is not really necessary, > unless you want to reset the metadata versions count of the objects > from 1 to 0. > > Also, about step 3, you can prepare a script with "create or alter" > statements of your procedures, triggers, etc. and run it using any > tool or even isql. > > []s > Carlos > Migration Guide to FB 3 > http://www.firebirdnews.org/migration-guide-to-firebird-3/ > <http://www.firebirdnews.org/migration-guide-to-firebird-3/> > > KSKSRScfs> Greetings! > > KSKSRScfs> Process 1: > KSKSRScfs> Via a script, I have successfully exported and migrated > KSKSRScfs> all data and objects from a FB1 database to FB3. > KSKSRScfs> Creating the objects originally had just a few errors but > KSKSRScfs> those have been fixed and it now goes across cleanly, no errors. > KSKSRScfs> This process has been the one most widely recommended. > > KSKSRScfs> Process 2: > KSKSRScfs> With the corrected database that goes cleanly to FB3, I tried the > following: > KSKSRScfs> 1. Backup the database with FB1. > KSKSRScfs> 2. Restore the database with FB3. > KSKSRScfs> 3. Executed two of IB Expert’s functions: a) Recompile all > KSKSRScfs> Procedures and b) Recompile all Triggers. (No errors) > KSKSRScfs> 4. Performed a backup / restore with no errors. > > KSKSRScfs> My question: is Process 2 an acceptable path? The only > KSKSRScfs> reason I ask is one of my customers has many millions of > KSKSRScfs> records and I believe Process 2 will save me a weekend of > KSKSRScfs> work. (My next step is to benchmark how long Process 1 > KSKSRScfs> will take for this customer’s database). > > KSKSRScfs> Many Thanks! > > KSKSRScfs> Kevin > > > [Non-text portions of this message have been removed]
