On January 30, 2006, IBM released a free version of their DB2 UDB database. Here is the quote from their web page: "DB2 Express-C is completely free to download, develop, deploy, test, run, embed, and redistribute."

http://www-306.ibm.com/software/data/db2/udb/edition-expressc.html

I simply could not resist the temptation to add support for DB2.  This was a personal challenge as I have never developed for DB2, but had wanted to ever since they added the ability to support stored procedures a few short years ago.  SplendidCRM now supports all the major database platforms; this is something that SugarCRM has yet to accomplish.

So, for the last 4 days, I've been working on porting the 110 tables, 20 functions, 190 views, and 290 procedures from SQL Server to DB2.  Although I have yet to begin testing, my progress has been nothing short of phenomenal.  Here is a summary of the hours it has taken:

   7 hours to convert all tables (this includes installing DB2 multiple times)
   5 hours to convert all functions (this includes time understanding new syntax)
   10 hours to convert all views
   11 hours to convert all procedures
   2 hours to convert the default data scripts

One interesting side-effect of this project is that I was able to find some obscure bugs that would likely only appear when testing the Oracle or MySQL implementations.