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
