Database migration in Base

[Wols Lists]

On 10/04/18 16:55, Jean-Pierre Ledure wrote:
> Does this mean that once a .odb file containing an embedded HSQLDB
> database is opened in LO 6.1 there is no way back ? That file cannot be
> accessed anymore by a LO <= 6.0 user ? Is this acceptable ?

I believe this is normal for a lot of SQL databases. C&D explicitly says
the user is not supposed to know the implementation detail, and it's
normal to update the on-disk format, with the inevitable consequence
that old versions of the program cannot access newer versions of data.

I guess I'm spoilt - WordPerfect and Pick treat that as a serious
regression, but actually that approach seems very unusual. It requires
careful and extensible design from the start, which seems, shall we say,
unusual.

Cheers,
Wol