|
S.No
|
Sql Server 2005
|
Sql Server 2008
|
|
1
|
XML datatype is introduced.
|
XML datatype is used.
|
|
2
|
Cannot
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.
|
10/18/2013
Difference between SQL Server 2005 and SQL Server 2008
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment