Tag Archives: software

Back with SQL Script Creator… almost

SQL Script Creator Splash Screen

Being annoyed by creating a cursor script in SQL and having to define tons of variables manually I wondered if there was any tool to aid in this process. I quick google did not yield promising results. So spend the weekend conjuring up an application that eases the script creation by providing specialized generators to create scripts automatically from a given SELECT statement. It works pretty well and will be tested further in the next week until I’ll release it here under some opensource license.

SQL Script Creator Screenshot

Putting this app together thought me some new things about the settings and localization concepts of .NET 2.0. Two articles that got me introduced to the concept are the tutorial Localization in ASP .NET 2.0 on ondotnet.com and the detailed article
Localization Practices for .NET 2.0 on theserverside.net.

Backup.net

I’ currently thinking about a backup strategy for my linux server. I have several subversion repositories und home directories with imap maildirs that I definately don’t want to loose in case my server disc crashes. Actually I have been very lucky so far with not backing up most of my data for years. Maybe that’s why I feel, that I have to do something in that area.

Anyway, I have about 1-2GB of data, most of which doesn’t change a lot, but it should be stored daily. I’am looking for some kind of network backup solution for storing backups on my workstation or friends’ servers on a VPN. While searching, I came across DIBS: Distributed Internet Backup System which uses a peer to peer approach to store recovery data on serveral distributed servers. From the manual it looks promising and quite mature but I’m not sure if I’ll find enough reliable servers with a decent internet connection to use it.

Bacula looks really interessting but might be overkill in my situation. I like the fact that it provides clients for different OSes so that you can use it as a single backup solution even for the windows clients in your network. It is mainly built for larger networks with distributed backup and storage servers for a large number of clients. I don’t think I’ll invest the time to set up the different server components for this one, though.

Possibly I’ll end up with a tar, scp or rsync solution that copies backups to my windows workstation or other peers in my VPN. linux-backup.net and this IBM article of automation of backups on linux give some useful example for such a do-it-yourself backup solution.

Update: I found one more popular opensource backup application which is called Amanda which provides a similar feature set like Bacula.