Thankfully I moved from D1 to D3 many years ago. So now just need to get to FB3.
Cheers, Kevin > On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support] > <firebird-support@yahoogroups.com> wrote: > > 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: firebird-support@yahoogroups.com > <mailto:firebird-support@yahoogroups.com> <firebird-support@yahoogroups.com > <mailto:firebird-support@yahoogroups.com>> > Sent: 30 April 2020 15:23 > To: Firebird Support <firebird-support@yahoogroups.com > <mailto:firebird-support@yahoogroups.com>> > 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] > > > [Non-text portions of this message have been removed]