Subject | firebird migration 1.03 to 2.5.0 |
---|---|
Author | Michele Federici |
Post date | 2011-05-12T14:40:13Z |
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]
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]