Reverting from 1.3 to 1.2

30 views
Skip to first unread message

marcolopes

unread,
Apr 17, 2012, 3:33:08 PM4/17/12
to h2-da...@googlegroups.com
Is there any known incompatibility downgrading from the last 1.3 version to the last 1.2?

The databases where created with 1.2.147, upgraded using 1.3.166, and now are running on 1.2.147 again

Thanks.

Thotheolh

unread,
Apr 18, 2012, 11:16:55 AM4/18/12
to h2-da...@googlegroups.com
I think you can dump the database into a SQL script using SCRIPT function and downgrade to 1.2 series and then load the SQL script. The main issue would be some differences in SQL languages between 1.2 and 1.3 series of H2 which you need to dig up from the change logs.

marcolopes

unread,
Apr 18, 2012, 4:22:41 PM4/18/12
to h2-da...@googlegroups.com
My doubt is: are there any "structural" differences between the 1.2 and 1.3 versions that make the the DATABASE itself incompatible?

Thomas Mueller

unread,
Apr 23, 2012, 1:03:24 PM4/23/12
to h2-da...@googlegroups.com
Hi,

In version 1.3, CLOB and BLOB data is stored in the database file itself by default.

In any case, I would use the script / runscript tool or statements.

Regards,
Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/dpgalEEu7DMJ.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
Reply all
Reply to author
Forward
0 new messages