Difference between MSDE and SQL Server Express 2005

SQL SERVER Express edition is a cut down version of SQL SERVER 2005 and the next evolution of MSDE(MSDE is a cut down version of SQL Server 2000).

  • MSDE maximum database size is 2GB but in SQL SERVER Express has around 4GB.

  • In terms of programming language support MSDE has only TSQL, but SQLSERVER Express has TSQL and .NET.

  • SQL SERVER Express does not have connection limitation, which MSDE had and was controlled through the Workload governer.

  • There was no XCOPY support for MSDE, SQL SERVER Express has it.

  • DTS is not present in SQL SERVER express while MSDE has it.

  • SQL SERVER Express has reporting services while MSDE does not.

  • SQL SERVER Express has native XML support and MSDE does not.

No comments: