Re: backup encrypted database
Thomas, Thanks for pointing that out, I did not realize that SCRIPT allowed that. Your solution will work fine. Thanks again! On Feb 22, 11:44 pm, Thomas Mueller wrote: > Hi, > > I would use the "script" statement; it does does support an encrypted > target:http://h2database.com/html/grammar.html#script > > It's true that the "backup" statement doesn't encrypt the output file > directly; in theory you could use the "encrypting file system" > implementation, but this implementation is not complete yet. > > Regards, > Thomas > > On Mon, Feb 20, 2012 at 8:21 PM, Adam McMahon > > > wrote: > > > > > > > > > Hi H2 Group, > > > I have an H2 database that I use the built in AES file encryption. I > > would like to find a good backup solution in which the backup is also > > encrypted using the same file password > > > I could copy the database file, but the database will always be > > running, so simply copying the file may not be a good solution. And, > > if I understand the sql SCRIPT and BACKUP commands correctly they will > > not encrypt the output file. Any ideas? > > > Thanks, > > > -Adam > > > -- > > You received this message because you are subscribed to the Google Groups > > "H2 Database" group.> To post to this group, send email to > h2-database@googlegroups.com > . > > To unsubscribe from this group, send email to > > h2-database+unsubscr...@googlegroups.com .> For more options, > visit this group at > > http://groups.google.com/group/h2-database?hl=en. > > > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
backup encrypted database
Hi, I would use the "script" statement; it does does support an encrypted target: http://h2database.com/html/grammar.html#script It's true that the "backup" statement doesn't encrypt the output file directly; in theory you could use the "encrypting file system" implementation, but this implementation is not complete yet. Regards, Thomas On Mon, Feb 20, 2012 at 8:21 PM, Adam McMahon > wrote: > Hi H2 Group, > > I have an H2 database that I use the built in AES file encryption. I > would like to find a good backup solution in which the backup is also > encrypted using the same file password > > I could copy the database file, but the database will always be > running, so simply copying the file may not be a good solution. And, > if I understand the sql SCRIPT and BACKUP commands correctly they will > not encrypt the output file. Any ideas? > > Thanks, > > -Adam > > -- > You received this message because you are subscribed to the Google Groups "H2 Database" group. > To post to this group, send email to > h2-database@googlegroups.com . > To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com . > For more options, visit this group at http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
backup encrypted database
Hi H2 Group, I have an H2 database that I use the built in AES file encryption. I would like to find a good backup solution in which the backup is also encrypted using the same file password I could copy the database file, but the database will always be running, so simply copying the file may not be a good solution. And, if I understand the sql SCRIPT and BACKUP commands correctly they will not encrypt the output file. Any ideas? Thanks, -Adam -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.