We have only around 4 tables and dont have foreign key references between them, so deleting older db is not a problem. Let me know if there is still a option to split date wise.
Also thought about the other solution you provided ( Creating daily db ), but we have a UI where a date range based is provided. User can select a week or month range and data should be shown for that. In case we create daily db, is there a option to combine data from DB of different dates and perform search on that. Thanks, Naren. On Wednesday, May 17, 2017 at 7:01:45 PM UTC-4, Kerry Sainsbury wrote: > > 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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
