Subject firebird migration 1.03 to 2.5.0
Author Michele Federici
Hi,

I'm trying to migrate a firebird database from 1.03 to 2.5.0 (big
steps!) but � ve some problem on restore.

I created a database backup (mydb.gbk) with 1.03 engine. The restore
of mydb.gbk on 1.03 engine works fine. If i try to restore on 2.5.0
engine I've two errors.

First error report me

gbak:restoring table MY_TABLE
gbak: restoring column COL1
gbak: restoring column COL2
gbak: ERROR:Malformed string
gbak:Invalid metadata detected. Use -FIX_FSS_METADATA option.

So i restored mydb.gbk with -FIX_FSS_METADATA ISO8859_1.
GBAK restored MY_TABLE fine but it's stopped on

gbak:restoring data for table MY_TABLE2
gbak: 10000 records restored
gbak: 20000 records restored
gbak: 30000 records restored
gbak: 40000 records restored
gbak: 50000 records restored
gbak: 60000 records restored
gbak: 70000 records restored
gbak: 80000 records restored
gbak: 90000 records restored
gbak: 100000 records restored
gbak: 110000 records restored
gbak: 120000 records restored
gbak: 130000 records restored
gbak: 140000 records restored
gbak: 150000 records restored
gbak: ERROR:value exceeds the range for valid timestamps
gbak: ERROR:gds_$send failed
gbak:Exiting before completion due to errors

Which are min and max values timestamp on 2.5? I think i need to find
wrong values in mydb and insert a correct values.
Use of -FIX_FSS_METADATA is correct or i've side effects?

Some additional info
- dialect 1
- character set none
- contains views, procedure, udf, triggers, generators

Thank you
Michele


[Non-text portions of this message have been removed]