Hi Friends, I am explaining differences between sql server 2002 and sql server 2005
Sr.No
|
2002
|
2005
|
1
|
Query Analyser and Enterprise manager
are separate.
|
Both are combined as SSMS(Sql Server
management Studio).
|
2
|
No XML data type is used.
|
XML data type is introduced.
|
3
|
We can create maximum of 65,535
databases.
|
We can create 220-1
databases.
|
4
|
Exception Handling mechanism is not
available
|
Exception Handling mechanism is
available
|
5
|
There is no Varchar(Max) data type is
not available
|
Varchar(Max) data type is introduced.
|
6
|
DDL Triggers is not available
|
DDL Triggers is introduced
|
|
RowNumber function for paging is not available
|
RowNumber function for paging is
introduced
|
7
|
Table fragmentation facility is not
available
|
Table fragmentation facility is
introduced
|
8
|
Full Text Search facility is not
available
|
Full Text Search facility is
introduced
|
9
|
Bulk Copy Update facility is not available
|
Bulk Copy Update facility is
introduced
|
10
|
Data Encryption concept is not
introduced
|
.Cannot encrypt the entire database
|
11
|
Cannot compress the tables and
indexes.
|
Can Compress tables and
indexes.(Introduced in 2005 SP2)
|
12
|
No varchar(max) or varbinary(max) is
available.
|
Varchar(max) and varbinary(max) is
used.
|
13
|
Data Transformation Services(DTS) is
used as ETL tool
|
SQL Server Integration Services(SSIS)
is started using from this SQL Server version and which is used as ETL tool
|
No comments:
Post a Comment