We have an app written in C# (Visual Studio.NET 2003). It uses MSDE 2000 as the database.
It is installed on all our users Windows XP (Pentuim 4, 2.5 GHz, 256 MB RAM, 40 GB HDD)
computers. We used Microsoft Data Application Blocks (not the newer Enterprise Library) as
the database abstraction layer. The app is sweet and the users love it.
Now, we reached the 2GB treshhold. We cannot import in any more data from our
legacy systems. Our suggestion was to delete transaction data that was more
than three years old. We did not get permission. shucks.. That means we should upgrade to
SQL 2005 Express which has a 4GB database limit.
Upgrading the database by moving all the tables, stored procs and udf’s is no big deal.
An added bonus is an easier installation for our IT support team , and a free database
management tool (SQL Server Management Studio Express?).
The big question is : can we retain the same source code base ie. will DAAB be compatible
with SQL 2005 Express ? what are the alternative solutions? Thanks in advance.
Cheers from Nigeria,
Steve Faleiro
Programmer.