Fog Creek Software
Discussion Board




MSDE as an alternative to SQL Server?

Has FogBUGZ been tested with MSDE  (Microsoft Desktop Engine)?  It may provide the advantages of SQL Server while being royalty-free.

From its website (http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp)

The SQL Server 2000 Desktop Engine (MSDE 2000) is a data engine built and based on core SQL Server technology. With support for single- and dual-processor desktop computers, MSDE 2000 is a reliable storage engine and query processor for desktop extensions of enterprise applications. The common technology base shared between SQL Server and MSDE 2000 enables developers to build applications that can scale seamlessly from portable computers to multiprocessor clusters.

Bernard Vander Beken
Saturday, February 16, 2002

It would almost work, except that MSDE does not include full-text search queries which is one of the best reasons to use SQL Server.

Joel Spolsky
Monday, February 18, 2002

When you say "almost work", are you just referring to the lack of free-text searching? Or is there something else that wouldn't work?

Thank you.

Mary-Marshall Teel
Tuesday, April 09, 2002

*  Recent Topics

*  Fog Creek Home