Compatibility issues when downgrading H2 database from v2.1.214 to v1.4.196

[Niv F]

Hi,

We cannot import an SQL script file, which was exported from an H2 v2.1.214 database, to H2 v1.4.196 database.

It seems that the issue is with the CHARACTER VARYING & CHARACTER LARGE OBJECT data types, which are not recognized in H2 v1.4.196.

Has anyone encountered this issue?

Is there any configuration that can be set to export an H2 v1-compatible SQL script from H2 v2.1.214 database?

Thanks,

Niv.

[Christian Buchegger]

I remember some post on this list or on the bugtracker saying that there is no support for going back. The options are either edit the exported sql to match the old syntax of do a date export/import using other tools avaible into an empty schema on the old version.