Difference
between MSDE and SQL Server Express 2005
-
S.NoMSDESQL Server Express 20051 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 2MSDE maximum database size is 2GBSQL SERVER Express has around 4GB.3In terms of programming language support MSDE has only TSQLSQLSERVER Express has TSQL and .NET.4MSDE had and was controlled through the Workload governerSQL SERVER Express does not have connection limitation5There was no XCOPY support for MSDESQL SERVER Express has it.6MSDE has DTSDTS is not present in SQL SERVER express7MSDE does not have reporting servicesSQL SERVER Express has reporting services8MSDE does not have native XML supportSQL SERVER Express has native XML support
No comments:
Post a Comment