Hello mojoPortal community,
I would like to gather your feedback about something I am contemplating. Not long ago I implemented a new data layer for Sql Azure. I could have just made changes in the MS SQL data layer to make it compatible. The biggest change would be that ntext fields must be changed to nvarchar(max). There are a few other changes needed to support Sql Azure but that is the main issue as we are currently using ntext all over the place. The problem is that nvarchar(max) was introduced in SQL 2005, so doing this would be explicitly dropping support for SQL 2000 in mojoPortal. Doing this would be very beneficial to me because I could consolidate into 1 data layer that supports SQL 2005, 2008, and Azure and this would reduce maintenance by eliminating the need for an extra data layer for Sql Azure.
So, what I'm trying to guage is how many of you are using SQL 2000?
It is 10 year old technology after all and at some point it seems like we should be able to drop support for it. If I were to drop support for it sometime soon how many of you would be chasing me with pitch forks?
Thanks,
Joe