Blog

Difference between Sql server 2005 and 2008

By Purushottam Rathore Jun 13, 2011
Difference between Sql server 2005 and 2008.
There are some differences between both.
 
Sr No SQL Server 2005 SQL Server 2008
1 XML datatype is introduced. XML datatype is used.
2 Can not encrypt the entire database. Can encrypt the entire database introduced in 2008.
3 Datetime is used for both date and time. Date and time are seperately used for date and time
4 No table datatype is included. Table datatype introduced.
5 SSIS is started using. SSIS avails in this version.
6 CMS is not available.

Central Management Server(CMS) is Introduced.

7 PBM is not available

Policy based management(PBM) server is Introduced.