Subject | FB1.5 and FB1.0 - migration issue |
---|---|
Author | elleffeci |
Post date | 2005-07-29T06:28:36Z |
Hi all,
we are in the process of evaluating to migrate a working FB server
from v1.0 to v1.5 . Since this server is a 'mission critical' one, we
must not fail.
My concerns are:
1) SQL compatibility: can we be sure that *ALL* SQL queries in our
application, currently running on FB1.0, will be OK with FB1.5 without
touching the SQL?
2) backward migration: should any problem arise after installing and
using FB1.5, how can we 'revert' back to v1.0?
3) can we hope in a performance gain by migrating to 1.5?
About point 2), we did some internal tests by
- gbak'ing our DB with gbak 1.0,
- restoring the DB with v1.5 gbak on a machine with FB1.5
- playing around with the new installation.
the questions now are:
a) is this the correct migration procedure?
b) is it possible to revert the DB back to v1.0 by gbak'ing it with
1.5 gbak and restoring it with v.1.0 gbak, or is there another procedure?
I think the main problem here should arise because of different
OnDiskStructure between 1.0 and 1.5 .
Thank you very much in advance,
Luca
we are in the process of evaluating to migrate a working FB server
from v1.0 to v1.5 . Since this server is a 'mission critical' one, we
must not fail.
My concerns are:
1) SQL compatibility: can we be sure that *ALL* SQL queries in our
application, currently running on FB1.0, will be OK with FB1.5 without
touching the SQL?
2) backward migration: should any problem arise after installing and
using FB1.5, how can we 'revert' back to v1.0?
3) can we hope in a performance gain by migrating to 1.5?
About point 2), we did some internal tests by
- gbak'ing our DB with gbak 1.0,
- restoring the DB with v1.5 gbak on a machine with FB1.5
- playing around with the new installation.
the questions now are:
a) is this the correct migration procedure?
b) is it possible to revert the DB back to v1.0 by gbak'ing it with
1.5 gbak and restoring it with v.1.0 gbak, or is there another procedure?
I think the main problem here should arise because of different
OnDiskStructure between 1.0 and 1.5 .
Thank you very much in advance,
Luca