Summary: | Embedded Firebird : conversion ODB files from Firebird 2.5 to Firebird 3.0 gives corrupted ODB files | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | ribotb <ribotb> |
Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED INVALID | ||
Severity: | normal | CC: | btomi96, golzio, lionel, miguelangelrv |
Priority: | medium | ||
Version: | 5.3.0.0.alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 51780 | ||
Attachments: | conversion |
Description
ribotb
2016-12-28 11:01:41 UTC
Created attachment 129983 [details]
conversion
Please take a look to: http://nabble.documentfoundation.org/Firebird-backward-incompatibility-tt4201036.html I think you need to do a backup with a gbak of 2.5 firebird version, and also restore from the backup with a gbak of 3.0 firebird version. In Spanish but here is a blog on how to do. https://firebird21.wordpress.com/2016/05/21/firebird-3-usando-bases-de-datos-anteriores/ (In reply to m.a.riosv from comment #2) > Please take a look to: > http://nabble.documentfoundation.org/Firebird-backward-incompatibility- > tt4201036.html > > I think you need to do a backup with a gbak of 2.5 firebird version, > I have a Firebird 2.5 Server installed on my PC. Therefore the archive file (firebird.fbk) is created with gbak 2.5. > and also restore from the backup with a gbak of 3.0 firebird version. > Why a restore of the archive file (firebird.fbk)? It's this archive file that must be embedded in the odb file to replace the firebird database (firebird.fdb). What is wrong? (In reply to ribotb from comment #3) > Why a restore of the archive file (firebird.fbk)? It's this archive file > that must be embedded in the odb file to replace the firebird database > (firebird.fdb). > > What is wrong? Please forgive, I was thinking on an ordinary firebird database. @tamas : is there some confusion here as to what needs to be done ? The "corrupted" message is because the manifest (META-INF/manifest.xml in the .odb ZIP structure) becomes inconsistent with the actual contents. Need to either update the manifest, or indeed do a restore to .fdb in a Firebird 3.0 (which will happen to work...) and include a 3.0 fdb and no fbk (LibreOffice will convert it to a fbk). To update the manifest, just replace within it: <manifest:file-entry manifest:full-path="database/firebird.fdb" manifest:media-type=""/> by <manifest:file-entry manifest:full-path="database/firebird.fbk" manifest:media-type=""/> Per Lionel's comment setting to new. Another thing that we would need to deal with if we have some kind of automatic converter set up one day. (In reply to Lionel Elie Mamane from comment #6) > Need to either update the manifest, > > To update the manifest, just replace within it: > <manifest:file-entry manifest:full-path="database/firebird.fdb" > manifest:media-type=""/> > by > <manifest:file-entry manifest:full-path="database/firebird.fbk" > manifest:media-type=""/> Hi, It works fine! In french "C'était simple et il suffisait d'y penser !" :-)) Thanks, Lionel! Perhaps, add that to the release notes ? Bernard I'd say just update the conversion instructions (on the wiki?) and then close this bug. (In reply to Lionel Elie Mamane from comment #9) > I'd say just update the conversion instructions (on the wiki?) and then > close this bug. Yes, for me. Let's do that then. Is INVALID the right resolution? (In reply to Tor Lillqvist from comment #11) > Let's do that then. Is INVALID the right resolution? INVALID seems inappropriate. |