[All]
Migration issues -- gbak & restore
Abstract: Migration issues -- gbak & restore
Problem:
In the V3.3 version of InterBase user was allowed to enter comments
for an index definition. If you have this comments field in the
systems table filled out with the user defined comments, and then
try to migrate to a V4.0 version of the database, the GBAK -restore
will fail giving the above error message.
The reason for this is that the ID number for the comments field in
the systems table has been changed in the version of V4.0 InterBase
from what it was in the V3.3 version..
Solution:
Note: this information pertains to migrating a v3.3 database to later
versions of InterBase.
The best solution is to drop the index on the V3.3 database. Then,
redefine the index without including the comments in the definition.
Later do a GBAK and GBAK -restore into a V4.0 database..
