using fb2.5

[rcmz]

Hi,

I have been using f2 2.5 for some time.

Do I go to fb4.0 or should I wait for fb5.0 ?

TIA

Ramiro

[Hugo Eyng | Datamais]

Hi.

FB 5.0 RC1 is already available.

I will migrate from 2.5 to 5.

Atenciosamente,

Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/a7ef3ee9-de0d-4fdb-98a6-051262585b68n%40googlegroups.com.

[Christian Diercks]

Anything above 2.5 is great… 

Sent from my iPhone

On Oct 18, 2023, at 6:29 PM, Hugo Eyng | Datamais <hugo...@gmail.com> wrote:



To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAPjsPP0vBGKKSe-f%3Dhv0PTLdrK3Kuy41H0drLxKh75Ba_wi%3Dcg%40mail.gmail.com.

[Ismael L. Donis Garcia]

+1 to FB 5.0

 

Best Regards

--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
Web Site: https://gitlab.uic.cu/ismael.donis/

----- Original Message -----

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAPjsPP0vBGKKSe-f%3Dhv0PTLdrK3Kuy41H0drLxKh75Ba_wi%3Dcg%40mail.gmail.com.

[Steve Naidamast]

I am still using Firebird 2.5.9 for my current development.  However, as soon as I am able, I will be upgrading to either 4.x or 5.x, if the latter is already been released for production purposes.

I agree with the Firebird Team, that we should all get ourselves off of 2.5.9, for those of us who are still using it, when it is possible.

In my case, I have to implement a lot of development so that the transition from 2.5.9 to 4.x or 5.x is as seamless as possible for the users of my project...

Steve Naidamast

Sr. Software Engineer

[Yordan Yanakiev]

Maybe one of the top priorities should be giving a proper tools for painless migration with just a single click.

[James Bond]

Hi,

Maybe a How to 

from 2.5, 3.0, 4.0 to 5.0

Ramiro

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/135cb88c-bf47-4db8-985e-a364f58bb8b0n%40googlegroups.com.

[Hugo Eyng | Datamais]

Hi.

There is a solution to migrate from 2.5 to 5.0 "with a single click".

Maybe, it is necessary some "tunning" for each case.

Recently Alexey Kovyazin linkedin.com/in/kovyazin  and  Edson Gregorio linkedin.com/in/edsongregorio promoted a meeting

and proposed a good solution in this direction. They also provided some scripts, organized in a way that we can indeed convert a 2.5 DB in a 5.0 DB

using one click or one "ENTER".

Atenciosamente,

Hugo

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/135cb88c-bf47-4db8-985e-a364f58bb8b0n%40googlegroups.com.

[Yordan Yanakiev]

The "some scripts" case is the issue. Nothing usually goes right, and this is not a single click but a endless nightmare.
The thing must be compile into a solid executable which is having just 2 boxes to browse for source and destination, and a single button "Convert", and since it is build from the creators of the FB - I believe all possible scenarious should be checked. Something which is for sure not achievable for someone which is just using the database without any need to know literally everything for it.

[Mark Rotteveel]

On 19-10-2023 19:53, Yordan Yanakiev wrote:
> Maybe one of the top priorities should be giving a proper tools for
> painless migration with just a single click.

The problem is that a single-click solution wouldn't work or account for
all case.

In its simplest form, backing up and restoring your database *will*
upgrade it, and you might just continue to work without having to do
*any* work.

However, this will not account for things like the new datatypes
returned by CURRENT_TIME and CURRENT_TIMESTAMP, which you can already
address when you're one Firebird 2.5.9 by switching to LOCALTIME and
LOCALTIMESTAMP. Or as a stopgap measure by setting the
DatatypeCompatibility setting in database.conf.

Other than that, there isn't really a lot a generic migration script
would (or could) need to address IMHO.

And possibly some other changes like built-in functions or aggregates
returning a different type might have an impact, but that wouldn't be
addressable by a migration script anyway, because some applications or
libraries will handle that without problems, and others might need some
work.

The reason it is recommended by some to create a new database and pump
the data, is because likely you'll need to make some changes for the
sake of your application and not for Firebird itself, and in that case
recreating and pumping the data is probably simpler to do.

Mark
--
Mark Rotteveel

[Karol Bieniaszewski]

Single click solution can exists only if you use Database by ISQL and work with it from there.

Then simply do backup/restore process, if it successfull, you have single click solution 😉

 

But in real world you use specialized applications which uses such DB.

Consider problems, no single click to resolve:

1. New Keyword introduced in Firebird and you have Table, Field or other object named like Keyword.
2. Ambigous field definition in sql, no automatic scripts can resolve it.
3. Changed query plan which brake some part of application.
4. …..

 

Regards,

Karol Bieniaszewski

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/63697fde-31e9-4887-8942-ac9f2f367572n%40googlegroups.com.

 

[Hugo Eyng | Datamais]

Dear Yordan.

I can not say the script(s) work for every FB DB 2.5 around the world. I never tried...

I can say that it worked for me, without recompiling the software. Of course, it is necessary to adjust some parameters in the firebird.conf, as Mark said.

Alexey and Edson (I mentioned above) are experts in FB and he did a great job. The scripts also recompile SP and triggers,  a process needed for the conversion.

The process: paste the 2.5 DB  in a directory "IN" and you will have 5.0 DB in a directory "OUT". Their solution is worth evaluating.

Again, it is possible that a very specific DB can depend on some extra tratament. 

Even some tool was make available by the FB team, I don´t believe that it would work 100% for every DB around the world without some "tunning". Furthermore, that it would take a lot of time, effort and costs to have almost the same result.

Mark wrote about important aspects which, if observed, reduce headaches.

Atenciosamente,

Hugo

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/63697fde-31e9-4887-8942-ac9f2f367572n%40googlegroups.com.