Hello. H2 has own script tool http://www.h2database.com/html/tutorial.html#upgrade_backup_restore and also SQL command for export. http://www.h2database.com/html/grammar.html#script SCRIPT NODATA TO 'filename.sql'
Your SQL script from IntelliJ is not valid. There is no data type TIMESTAMP WITH TIME ZONE(30, 10) it should be TIMESTAMP WITH TIME ZONE or TIMESTAMP(9) WITH TIME ZONE or something like it instead. http://www.h2database.com/html/datatypes.html#timestamp_with_time_zone_type Also this data type is fully supported only since H2 1.4.197, if you use some older version it's better to use simple TIMESTAMP data type. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
