Re: [libreoffice-users] Call for testers - automatic migration of embedded hsqldb Base files to embedded Firebird Base files
Hi all, have put the content of the mail I wrote to a bug-report: https://bugs.documentfoundation.org/show_bug.cgi?id=116944 Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Call for testers - automatic migration of embedded hsqldb Base files to embedded Firebird Base files
Hi *, have tested this kind of migration: Downloaded the daily build of 2018-04-11, 6.1.0.0.alpha0+ Opened the database, which is part of the Base Handbook: "Media_without_Macros". No comment like "Internal HSQLB" apperas at the bottom of the window. Tried to open the tablecontainer. No table apperas, but after some time the following message: Connection to datasource "Media_without_Macros" couldn't be established. firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 163 *BLOB caused by 'isc_dsql_prepare' I haven't set the experimental features to "yes". I wasn't asked if I want to change the database from HSQLDB to Firebird. Base should never be a playground for such a function. People will loos their data and will never again use LO after starting one database with this automatic. 1. An automatic migration should never be installed from a working internal database to a database, which is an "experimental feature" (Firebird) - and never means: also never with a daily build. 2. A migration should only be offered, never automatically, when internal Firebird database has been activated. 3. The migration should create a new database with the migrated content, not overwrite the old database. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Call for testers - automatic migration of embedded hsqldb Base files to embedded Firebird Base files
Hi all, One of TDF's recent tenders was to provide a means to automatically migrate embedded hsqldb ODB files to embedded Firebird ones. This has now been accomplished by Tamas Bunth, working for Collabora, and the code pushed to the master branch, so it should already be appearing in daily builds. Testing is needed to report any problems. At present, as I understand it, the conversion process is automatique and transparent, which means that in principle, the change is invisible to the user (bar any import errors, I imagine). The change is also irreversible, which means that at least for testing purposes, you should only use copies or specifically engineered test ODB files at the moment. The irreversible nature of the transformation means that it will no longer be possible for older versions of LO that do not support integrated Firebird databases (4.x and older ?) to be able to open the newly migrated ODB files. Please report any migration errors to the LibreOffice bugzilla. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted