Subject Re: [firebird-support] Re: Migrate firebird 1.5 to firebird 2
Author Martijn Tonies
> I have also tried the following using only firebird 2 gbak:
>
> $ /opt/firebird/bin/gbak FB_1.5.FDB -B BACKUP.FBK -user sysdba
> -password masterkey;
> $ /opt/firebird/bin/gbak BACKUP.FBK -C NEW_FB2.FDB -user sysdba
> -password masterkey;
>
> Then once logging onto NEW_FB2.FDB:
> using a table such as
> tbl(
> column1 varchar(255)
> column2 varchar(20)
> )
> create index BLAH on tbl(column1,column2)
>
> and got:
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -key size exceeds implementation restriction for index "TEST"

Have you read about key size in the Release Notes?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com