Migration issues -- gbak & restore

By: Borland Staff

Abstract: V3.3 version of InterBase user was allowed to enter comments for an index definition, and trying to migrate to V4.0 will generate an error.

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..     

Server Response from: ETNASC03