On Mon, 2008-04-28 at 00:52 -0400, Drew Jensen wrote: > The easiest version control system is just to create snapshots - > "File>Save AS" and give the file a name with a date component.
I agree. I killed an entire morning looking over "bazaar" (supported by a company called Canonical) and while I think the integration with the system is "clean" I think it's more than what I need right now. I decided that simply emailing versions to myself as I go along might be the best way as email seems perfect for that type of thing. The file can be sent as an attachment and the actual body of the email can be your change log. It's dated and timestamped. It seems perfect. I think the only issue might be security if one cares about that sort of thing. I suppose encrypting the backup but...... > One tip - compact your file before you do the saves. ( For instance, > your Base file might be 1,473K currently - if you compact it - it > would > be only 770K [how did I know that?] ) > To do this: > Open the SQL window ( Tools>SQL) > Enter the command > CHECKPOINT DEFRAG > Click on the execute button I will look into doing this. Will this by any chance improve the performance of the database? I've found that searching takes much more time as I both add data to the database and modify reports etc. > But - if you just want to create backups of the database: > > HSQL supports the SCRIPT command. Using this you can extract all the > commands to rebuild your database schema ( the tables, views, indexes > and constraints ) and the data to a single text file. Even if you > have > binary data in your file it will be extracted in a textual form. This > file can be large, but can also be compressed with any standard > archiving application and the compression ratio is usually very large. I hate to be dense, and I plan on doing my own research on exactly what a schema is in relation to BASE, but what benefit does extracting the schema achieve? How is that beneficial in backing up the database incrementally? Patience yields far greater results than brute force or rage ever could so relax......it's just life !!!
