I guess you can just extract the Procedures and Triggers DDL in
IBExpert, with the option of using "CREATE OR ALTER", and run it in
the restored DB.

If you have more doubts about the migration process, you may wish to
take a look at my Migration Guide to FB 3 eBook at
https://www.firebirdnews.org/migration-guide-to-firebird-3

Carlos
www.firebirdnews.org - www.FireBase.com.br

KSKSRScfs> Cool. I will try the IB Expert Data Export feature first
KSKSRScfs> on the new/empty FB3 database.

KSKSRScfs> If I have to recompile all objects, is there an “easy” way to do this?

KSKSRScfs> Thanks!
KSKSRScfs> Kevin



KSKSRScfs>

>> On Oct 2, 2019, at 10:24 AM, 'Carlos H. Cantu' listas@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
>>
>> 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/ <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
>>
>>
>>

KSKSRScfs> [Non-text portions of this message have been removed]



KSKSRScfs> ------------------------------------
KSKSRScfs> Posted by: Kevin Stanton <kevin.stanton@...>
KSKSRScfs> ------------------------------------

KSKSRScfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

KSKSRScfs> Visit http://www.firebirdsql.org and click the Documentation item
KSKSRScfs> on the main (top) menu. Try FAQ and other links from the left-side menu there.

KSKSRScfs> Also search the knowledgebases at
KSKSRScfs> http://www.ibphoenix.com/resources/documents/

KSKSRScfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
KSKSRScfs> ------------------------------------

KSKSRScfs> Yahoo Groups Links