Did you know that SQL Server Express now has Full-Text Indexing? With the soon to be release of our DotNetNuke search module, which requires SQL Server Full-Text Indexing, I thought it would be helpful to make a post here for those who did not know the differences between SQL Server Express versions.
SQL Server Express Edition Comparison
You have several specific products to choose from when you install SQL Server Express Edition Use the following table to see how features for SQL Server compare across other Express Edition products.
|
Express Edition Products for SQL Server Compared |
| Feature |
SQL Server 2005 Express Edition |
SQL Server 2005 Express Edition with Advanced Services |
SQL Server 2005 Express Edition Toolkit |
| Database Engine |
* |
* |
|
| Client Components |
* |
* |
* |
| Full Text Search |
|
* |
|
| Reporting Services |
|
* |
|
| Management Studio Express |
|
* |
* |
| Business Intelligence Developer Studio |
|
|
* |
Each SQL Server Express Edition product has a specific use. Read the following sections to learn how each Express Edition product for SQL Server compares to the others.
SQL Server 2005 Express Edition
How does the Express Edition of SQL Server compare to other SQL Server Express Edition products? SQL Server Express Edition is perfect for use as an embedded database for a desktop application that requires a fully functional SQL Server Database Engine. SQL Server Express offers the smallest package size for faster downloads or to conserve space on deployment media.
SQL Server 2005 Express Edition with Advanced Services
How does the Express Edition with Advanced Services for SQL Server compare to the other SQL Server Express Edition products? SQL Server 2005 Express Edition with Advanced Services is perfect for use as a backend to a small, multiuser application that requires more advanced features such as Web reporting or Full-text Search.
SQL Server 2005 Express Edition Toolkit
How does the Express Edition Toolkit for SQL Server compare to other SQL Server Express Edition products? Install this package if you need the management tools and client components, but do not need the Database Engine. |
|
 |
Source: MSDN
Ready to download SQL Server 2005 Express with Advanced Services (has Full-Text Index)? Its free and here.