Subject | Re: [firebird-support] Unreadable file & Firebird to MySQL data migration |
---|---|
Author | Helen Borrie |
Post date | 2010-11-29T20:50:18Z |
At 04:33 AM 30/11/2010, Pierre Polome wrote:
In aliases.conf:
wh28 = h:\databases\wh28\rtff.fdb
From isql:
c:\Programs\Firebird\Firebird_2_0\bin>isql dev1:wh28 -user sysdba -password zzzzzzzz
Database: dev1:wh28, User: sysdba
SQL> show database;
Database: dev1:wh20
Owner: SYSDBA
PAGE_SIZE 1024
Number of DB pages allocated = 3772
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 289152
Transaction - oldest active = 289501
Transaction - oldest snapshot = 289501
Transaction - Next = 289504
ODS = 10.1
Default Character set: UNICODE_FSS
SQL> show tables;
ASKPHABET SEQUENCEUR
TCOLLABORATEUR TCOLLABORATEURPOSITION
TCOMPETENCE TDEFINITIONFONCTION
TDETAILEVALUATION TDETAILMESURE
TDETAILPLANFORMATION TDIPLOME
TDIPLOMEAQUIS TDIPLOMEREQUIS
TETAPE TEVALUATION
TEXPERIENCE TEXPERIENCEAQUISE
TEXPERIENCEREQUISE TFAMILLE
TFONCTION TFONCTIONPARETAPE
TFORMATION TFORMATIONAQUISE
TGROUPETACHES TLANGUE
TLIENPARVUE TLIENSTRUCTURE
TMESURABLE TMESURABLEPARREPONSE
TMISSION TMISSIONPARPOSTE
TMISSIONPARSTRUCTURE TMODELEEVALUATION
TNIVEAUDIPLOME TOCCUPATION
TPLANFORMATION TPONDERATIONPARSAVOIR
TPONDERATIONPARTACHE TPOSITION
TPOSTE TPOSTEPARETAPE
TPROCESSUS TREPONSEEVALUATION
TRESPONSABILITE TRESPONSABILITEPARPOSTE
TRESPONSABILITEPARSTRUCTURE TSAVOIR
TSAVOIRPARFORMATION TSAVOIRPARPOSTE
TSESSIONEVALUATION TSEUIL
TSPECIALITEDIPLOME TSTRUCTURE
TSTRUCTUREPARETAPE TSTRUCTUREPARVUE
TTACHE TTACHEPARPROCESSUS
TTACHESPARFONCTION TTHEMECOMPETENCE
TTRADUCTIONDYNAMIQUE TTYPEDIPLOME
TTYPEEVALUATION TTYPEFORMATION
TTYPELIEN TTYPESTRUCTURE
TVALEURPERMISE TVALEURSTRADUITES
TVERSION TVUE
SQL>
I don't have time to do the 28Mb download of Razorsql to test that, sorry.
Is it possible you are trying to open the database without having a Firebird server actually running?
./heLen
>Hello,I'm new to firebird, and for one of my customer I need to migrateIt is a v.1.5 database. Firebird servers > v.1.5 should be able to open it.
>a firebird database to a MySQL one.
>My customer sent me some .fdb file, but I can't read them. I can read
>the sample one added by the installation package (2.5).I'm using
>razorsql to do this on a Mas OS X.6.5
>I'm not sure, but maybe the file is for a 1.5 or something like that.
>Could somebody put me on the wayYou can find the file at:I had no problem opening your database under Firebird 2.0.6 on Windows, using isql and a couple of other tools.
>http://warehouse.twenty8prod.com/rtff.fdb
In aliases.conf:
wh28 = h:\databases\wh28\rtff.fdb
From isql:
c:\Programs\Firebird\Firebird_2_0\bin>isql dev1:wh28 -user sysdba -password zzzzzzzz
Database: dev1:wh28, User: sysdba
SQL> show database;
Database: dev1:wh20
Owner: SYSDBA
PAGE_SIZE 1024
Number of DB pages allocated = 3772
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 289152
Transaction - oldest active = 289501
Transaction - oldest snapshot = 289501
Transaction - Next = 289504
ODS = 10.1
Default Character set: UNICODE_FSS
SQL> show tables;
ASKPHABET SEQUENCEUR
TCOLLABORATEUR TCOLLABORATEURPOSITION
TCOMPETENCE TDEFINITIONFONCTION
TDETAILEVALUATION TDETAILMESURE
TDETAILPLANFORMATION TDIPLOME
TDIPLOMEAQUIS TDIPLOMEREQUIS
TETAPE TEVALUATION
TEXPERIENCE TEXPERIENCEAQUISE
TEXPERIENCEREQUISE TFAMILLE
TFONCTION TFONCTIONPARETAPE
TFORMATION TFORMATIONAQUISE
TGROUPETACHES TLANGUE
TLIENPARVUE TLIENSTRUCTURE
TMESURABLE TMESURABLEPARREPONSE
TMISSION TMISSIONPARPOSTE
TMISSIONPARSTRUCTURE TMODELEEVALUATION
TNIVEAUDIPLOME TOCCUPATION
TPLANFORMATION TPONDERATIONPARSAVOIR
TPONDERATIONPARTACHE TPOSITION
TPOSTE TPOSTEPARETAPE
TPROCESSUS TREPONSEEVALUATION
TRESPONSABILITE TRESPONSABILITEPARPOSTE
TRESPONSABILITEPARSTRUCTURE TSAVOIR
TSAVOIRPARFORMATION TSAVOIRPARPOSTE
TSESSIONEVALUATION TSEUIL
TSPECIALITEDIPLOME TSTRUCTURE
TSTRUCTUREPARETAPE TSTRUCTUREPARVUE
TTACHE TTACHEPARPROCESSUS
TTACHESPARFONCTION TTHEMECOMPETENCE
TTRADUCTIONDYNAMIQUE TTYPEDIPLOME
TTYPEEVALUATION TTYPEFORMATION
TTYPELIEN TTYPESTRUCTURE
TVALEURPERMISE TVALEURSTRADUITES
TVERSION TVUE
SQL>
I don't have time to do the 28Mb download of Razorsql to test that, sorry.
Is it possible you are trying to open the database without having a Firebird server actually running?
./heLen