[Libreoffice-bugs] [Bug 117090] EDITING: Firebird: migration: View definitions are lost from embedded hsql files using functions unknown to Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117090

--- Comment #10 from Gerhard Weydt <gerhard.weydt at t-online.de> ---
Looking at all the bug reports regarding the migration to Firebird that have
already been entered one must conclude that it will be impossible to cover all
eventualities that might be happening at the conversion. But it seems that the
conversion strategy still supposes that this can be done.
The impossibility of arriving at a 100 % conversion to Firebird should be
recognised. The efforts to get at near to 100 % as possible should certainly be
continued, because it is indispensable that the migration works generally. But
we must face the fact that there will be some cases not covered by the
migration routines, no matter how long we try to complete the migration code;
and I think there is not even time to try to arrive at a "complete" process,
because there is some deadline for the migration to Firebird.
So there should be an easy way to access all the information of features that
caused problems when migrating a database document from HSQLDB to Firebird,
such that it is quite easy to supply the (hopefully rare) missing features to
the migrated Firebird database manually.
As I have not enough insight into the details of the migration process, I can
only offer some general ideas:
1) The easiest way (regarding implementation) would be to supply a very serious
warning, when a database document should be converted, to always do this, first
of all, with a copy, or to save a copy beforehand, so that one always has an
original document to refer to, in case of problems.
2) Unfortunately, some people might ignore even this serious warning, so a
prompt to save the old state with a differnt name would perhaps be helpful.
3) I understand that the old HSQLDB is still stored within the database
document aftre the migration. If so, then proposal 2) would perhaps be
unnecessary, but only if there is an easy way to access this content, and the
information how to access it is adequately published. I don't know where, but
the migration process should supply a link or information where to find it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180606/bb17fe03/attachment.html>