Firebird 3 by default [was: minutes of ESC call ...]

[Jan Holesovsky]

Hi Lionel,

Lionel Elie Mamane píše v St 30. 11. 2016 v 14:55 +0100:

> The data definition (the name and structure of the tables) is just an
> SQL script in the ZIP structure of the .odb, so in principle you just
> replay that against Firebird with the firebird engine... The devil is
> in the details: If we run into places where the HSQLDB SQL dialect is
> not a subset of the Firebird SQL dialect, we'll have to deal with
> those places in some way. And suddenly we have to parse, and
> "understand", at least to some point, the saved HSQLDB SQL script to
> convert it to Firebird SQL. <shrug>

But that sounds that some kind of "best effort" conversion could be
achieved reasonably simply?  Ie. when there is no HSQLDB installed, try
to replay it as you suggested, and only report "You don't have HSQLDB"
in case the replaying failed :-)

All the best,
Kendy