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' lis...@warmboot.com.br > [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' lis...@warmboot.com.br > >> <mailto:lis...@warmboot.com.br> [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.stan...@rdb-solutions.com > <mailto:kevin.stan...@rdb-solutions.com>> > 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]
