Mechanized Assault & eXploration Reloaded

Subject: Database migration

---

So this is how I started dreaming in SQL. Since the punBB doesn't fit our purposes any more I decided to switch from a bbs to a portal system. I went out and seeked the net for some neat solutions. phpBB crossed my mind but it's huge and I wanted something easy to maintain but yet with basic portal functionality. Commercial solutions would fit nice but are way to expensive for my small wallet. Finally I found Viscacha and after an easy testinstall and toying around with it's functionality I decided to stick with it.

Unfortunately there was, as usually, no convert script for our database at hand. With a lot of chocolate I was able to regain my SQL knowledge from my early it-education days and I started the migration of our old bbsdatabase with an old backup I had at hand. After a lot of messing I was able to convert a satisfying amount of data including topics, posts and the users itself.

And heck, yes I went bleeding edge and checked out the latest svn version for Viscacha. This version may be a little bit buggy but has some really nice features like multiple document versions offering the opportunity for multilingualism. For now there will be german and english avaible. More languages may be avaible some day, too.

And now.. let's M.A.X.

---