8.24.2012

Difference between MSDE and SQL Server Express 2005

Difference between MSDE and SQL Server Express 2005

S.No
MSDE
SQL Server Express 2005
1 MSDE (Microsoft Data Engine) is a cut down version of SQL Server 2000 SQL SERVER Express edition is a cut down version of SQL SERVER 2005 and the next evolution of MSDE
2
MSDE maximum database size is 2GB
SQL SERVER Express has around 4GB.
3
In terms of programming language support MSDE has only TSQL
SQLSERVER Express has TSQL and .NET.
4
MSDE had and was controlled through the Workload governer
SQL SERVER Express does not have connection limitation
5
There was no XCOPY support for MSDE
SQL SERVER Express has it.

6
MSDE has DTS
DTS is not present in SQL SERVER express
7
MSDE does not have reporting services
SQL SERVER Express has reporting services
8
MSDE does not have native XML support
SQL SERVER Express has native XML support

No comments:

Post a Comment