Thanks Carlos - I have been reading your book - it’s been a great help. I need to refresh myself with it though.
Kevin

> On Oct 2, 2019, at 10:53 AM, 'Carlos H. Cantu' listas@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
>
> 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 <https://www.firebirdnews.org/migration-guide-to-firebird-3>
>
> Carlos
> www.firebirdnews.org <http://www.firebirdnews.org/> - www.FireBase.com.br <http://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@... <mailto:listas@...> [firebird-support] <firebird-support@yahoogroups.com <mailto: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/> <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@... <mailto:kevin.stanton@...>>
> KSKSRScfs> ------------------------------------
>
> KSKSRScfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> KSKSRScfs> Visit http://www.firebirdsql.org <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/ <http://www.ibphoenix.com/resources/documents/>
>
> KSKSRScfs> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> KSKSRScfs> ------------------------------------
>
> KSKSRScfs> Yahoo Groups Links
>
>
>

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