MSDE – The product and related issues
MSDE is a solution from Microsoft that enables developers to build freely distributable desktop and shared database solutions, which can easily migrate to SQL Server 7.0. This white paper discusses the MSDE product and issues related to the installation, database and migration of data; as well as an evaluation of its merits and demerits.
In preparing this document, we have referenced MSDN Library materials. We would also like to acknowledge the respective trademarks of the companies mentioned in this paper.
According to Microsoft, “MSDE is a fully SQL Server compatible database engine that can be used for (developing) desktop and shared database solutions built with either Visual studio 6.0 or Access 2000”. Once the applications are developed, developers can distribute their applications freely without bothering about issues of scalability. It supports upto 2GB of data for any individual database. The advantage of MSDE is that it runs as a service in the background, without the user having to get into the issues regarding its functioning....
