Hi Kevin, Can I ask what dialect you are going from and to?
Sorry I don’t have an opinion on P1 vs P2. Do you know why P1 is recommended over P2? As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?. Thanks, Jason From: [email protected] <[email protected]> Sent: 30 April 2020 15:23 To: Firebird Support <[email protected]> Subject: [firebird-support] FB1 to FB3 Greetings! Process 1: Via a script, I have successfully exported and migrated all data and objects from a FB1 database to FB3. Creating the objects originally had just a few errors but those have been fixed and it now goes across cleanly, no errors. This process has been the one most widely recommended. Process 2: With the corrected database that goes cleanly to FB3, I tried the following: 1. Backup the database with FB1. 2. Restore the database with FB3. 3. Executed two of IB Expert’s functions: a) Recompile all Procedures and b) Recompile all Triggers. (No errors) 4. Performed a backup / restore with no errors. My question: is Process 2 an acceptable path? The only reason I ask is one of my customers has many millions of records and I believe Process 2 will save me a weekend of work. (My next step is to benchmark how long Process 1 will take for this customer’s database). Many Thanks! Kevin [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
