Thank you. I already expected that. I did not seek full backward compatibility but since we use the database as a very plain table storage without foreign keys, complex joins etc we can live with compatibility for basic CREATE TABLE and INSERT statements only. So far we never had version differences manifest themselves in the SQL and I was hoping there was some kind of workaround.
On Thursday, 20 January 2022 at 06:14:42 UTC+1 Evgenij Ryazanov wrote: > Hello! > > H2 doesn't support and never supported downgrades. The oldest version that > can open database files or SQL scripts from 2.1.210 is H2 2.0.202. > > You need to edit the exported SQL by yourself. For example, you can use a > stream editor: > > sed "s/UUID '/'/" source.sql > target.sql > > But due to huge number of differences you may need to also edit many other > declarations. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/87efcf43-6429-438c-9009-c5b1bf1dfa06n%40googlegroups.com.
