I installed an application and SSW SQL Deploy popped up saying that I need to create a database on SQL Server. However I do not have a SQL Server Licence. Can I use MSDE instead? If so, what are the limitations? MSDE is a cut down version of Microsoft SQL Server 2000. MSDE provides Command Line methods to interact with its databases via tools like Osql.exe. Osql is a command line utility that allows the user to enter Transact SQL statements via a command line environment (e.g. from a DOS window).
SQL Server 2000 on the other hand provide a rich user interface along with tools like Query Analysers which removes the need to use command line tools.
One major consideration is the limitations that MSDE carries. The most important one is the maximum database size that MSDE allows. Currently this is set to 2GB. As your database size grows, this will be a serious consideration to upgrade/upsize to SQL Server 2000.
Also, MSDE only allows five concurrent users. This does not mean that it can only handle 5 users, it means that only 5 users can hit the database at the same time. If the application we are talking to receives 25 concurrent hits, MSDE will process only 5 at a time and queue the rest until a slot becomes available for processing.
If you are involved in a multi-server environment, you need to be aware that while it is possible to administer MSDE 2000 both locally and remotely MSDE 2000 cannot be remotely administered in a multi-server environment where transactions occur across servers.
|SQL Server 2005 (Express Edition)
The SQL Server 2005 Express Edition is a cut down version of the new SQL Server 2005. Server 2005 Express Edition provides lots of new and improved functionality, such as:
- A robust database for building dynamic applications
- Strong XML support
- Tools and features to enhance management and ease of use
- Easy installation and setup
- Scalability and performance
- Deep integration with Visual Studio 2005
- Robust security
See the Features page for details!
System requirements are available on the SQL Server Express download page.
Get the Data Sheet from here .