Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

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]  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 
> 
> 
> 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' lis...@warmboot.com.br 
> >>  [firebird-support] 
> >>  >> > 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/ 
> >>  
> >>  >> >
> >> 
> >> 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  >
> 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
> 
> 
> 



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

Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

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' lis...@warmboot.com.br 
>> [firebird-support]  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/ 
>> 
>> 
>> 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 
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

Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

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

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

Thanks!
Kevin



 

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



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

Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

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

[firebird-support] Migrating from 1.56 to FB 3 - making good progress

[Rustam rusta...@ukr.net [firebird-support]]

 
  The trick is populating the 3.0 database. I know there are data pump tools 
out there but they seem to be old?
Use "Extract Metadata" feauture of IBExpert with table data extraction


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

Try. If does not work - migrate to FB 2.0 using corresponding tutorial (if 
any), then to FB 2.5.9, then to FB 3.

E.g., backup DB with FB 1.5 -> restore with FB 2.0 -> backup with FB 2.0 -> 
restore with FB 2.5 -> backup with FB 2.5 -> restore with FB 3

At least 2.5 to 3.0 works perfect. Just download archives with required 
versions of FB (you need 'bin' directory with gbak.exe), and create bat-script 
with commands.

[firebird-support] Migrating from 1.56 to FB 3 - making good progress

[Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]]

Greetings!

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

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

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

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


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


Thanks in advance!

Kevin

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