Sorry Carlos - I read that wrong. Thought you were asking if the script could be run with isql.
Cheers, Kevin > On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' [email protected] > [firebird-support] <[email protected]> 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]
