Sequence of script output

12 views
Skip to first unread message

Mike Bray

unread,
Sep 24, 2019, 1:16:21 AM9/24/19
to H2 Database
I have an app that backups up its database and then restores from the backup. The restore does not recreate the database correctly because the creation of a view is in the backup before the creation of the underlying table. The sequence in the backup file is:

Creation of view
Creation of table
Insert of data

I have got around it by recreating the view after the restore but this is a bug in h2.
Reply all
Reply to author
Forward
0 new messages