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/ 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
