As you observe, the documentation doesn't talk about it. Where did you see it mentioned? I can't really even imagine how it would work; what happens to 'today' rows that have a foreign key reference to a 'yesterday' row when you delete the 'yesterday' files? Eek!
Given your actual objective I'd guess you can create a fresh database each day, named using 'todays' date, and programmatically delete the 'old' ones. On 18 May 2017 at 09:48, Narendran Balasubramaniam <[email protected]> wrote: > Hi, > > Can someone let me know how to split H2 DB files based on date ( daily > files ). Checked H2 documentation and it currently shows option to split > based on Size. > > Objective is to backup older dated files after a period of time and save > storage space. > > Thanks, > Naren > > -- > 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. > -- 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.
