KSKSRScfs> My question:
KSKSRScfs> Now that my 1.56 metadata script works w/out error with
KSKSRScfs> the 3.0 database, can I simply backup the 1.56 database and restore under FB 3?

In theory, yes. But note that the BLR of existing objects (procedures,
etc) are not recompiled when you do a restore, so, maybe you would
like to recreate all the procedures, triggers, etc. after restoring
the database to be sure that they are recompiled in FB 3.

Vlad said to me that there are some benefits of recompiling the
objects in FB 3: New engine could use new blr, also it will create
"debug info" for sp\triggers - it allows to produce error messages
with line numbers in call stack.


[]s
Carlos
https://www.firebirdnews.org/migration-guide-to-firebird-3/

KSKSRScfs> Greetings!

KSKSRScfs> I have been successfully created a script of the metadata
KSKSRScfs> in the 1.56 database, ran the script against FB 3 (all using IB Expert).

KSKSRScfs> Initial attempt only revealed about 20 or so errors. Not
KSKSRScfs> too bad for a fairly complex 20-year old database.

KSKSRScfs> I have fixed all the errors and can now run the script with no warnings or errors.

KSKSRScfs> The trick is populating the 3.0 database. I know there
KSKSRScfs> are data pump tools out there but they seem to be old?


KSKSRScfs> My question:
KSKSRScfs> Now that my 1.56 metadata script works w/out error with
KSKSRScfs> the 3.0 database, can I simply backup the 1.56 database and restore under FB 3?


KSKSRScfs> Thanks in advance!

KSKSRScfs> Kevin