The below are the basic differences between SQL Server 2000 and 2005.
1.In SQL 2000 Query Analyzer and Enterprise manager are separate where as in SQL 2005 both are combined as SSMS (SQL Server management Studio).
2.In SQL 2000 there is no XML data type where as in SQL 2005 XML data type is introduced .
3.In SQL 2000 exception Handling mechanism is not available where as in SQL 2005 exception handling mechanism is introduced.
4.In SQL 2000 there is no varchar(max) data type where as in SQL 2005 varchar(Max) data type is introduced.
5.In SQL 2000 there is no DDL Triggers where as in SQL 2005 DDL Triggers is introduced .
6.In SQL 2000 there is no Database Mirroring facility where as in SQL 2005 DataBase Mirroring facility is introduced .
7.In SQL 2000 there is no RowNumber function for paging where as in SQL 2005 Row Number function for paging is introduced .
8.In SQL 2000 Table fragmentation facility is not available where as in SQL 2005 table fragmentation facility is introduced .
9.In SQL 2000 Full Text Search facility is not available where as in SQL 2005 Full Text Search facility is introduced
10. In SQL 2000 Cannot compress the tables and indexes where as in SQL 2005 Can Compress tables and indexes.(Introduced in 2005 SP2)
11.In SQL 2000 No varchar(max) or varbinary(max) is available.where as in SQL 2005 Varchar(max) and varbinary(max) is used.
12.In SQL 2000 Data Transformation Services(DTS) is used as ETL tool where as in SQL 2005 SQL Server Integration Services(SSIS) is started used as ETL tool .
13.In SQL 2000 PIVOT and UNPIVOT functions are not available where as in SQL 2005 PIVOT and UNPIVOT functions are introduced.
14.In SQL 2000 bulk copy update is not possible where as in SQL 2005 bulk copy update is possible.
15.In SQL 2000 we can't encrypt the database where as in SQL 2005 we can encrypt the database.
1.In SQL 2000 Query Analyzer and Enterprise manager are separate where as in SQL 2005 both are combined as SSMS (SQL Server management Studio).
2.In SQL 2000 there is no XML data type where as in SQL 2005 XML data type is introduced .
3.In SQL 2000 exception Handling mechanism is not available where as in SQL 2005 exception handling mechanism is introduced.
4.In SQL 2000 there is no varchar(max) data type where as in SQL 2005 varchar(Max) data type is introduced.
5.In SQL 2000 there is no DDL Triggers where as in SQL 2005 DDL Triggers is introduced .
6.In SQL 2000 there is no Database Mirroring facility where as in SQL 2005 DataBase Mirroring facility is introduced .
7.In SQL 2000 there is no RowNumber function for paging where as in SQL 2005 Row Number function for paging is introduced .
8.In SQL 2000 Table fragmentation facility is not available where as in SQL 2005 table fragmentation facility is introduced .
9.In SQL 2000 Full Text Search facility is not available where as in SQL 2005 Full Text Search facility is introduced
10. In SQL 2000 Cannot compress the tables and indexes where as in SQL 2005 Can Compress tables and indexes.(Introduced in 2005 SP2)
11.In SQL 2000 No varchar(max) or varbinary(max) is available.where as in SQL 2005 Varchar(max) and varbinary(max) is used.
12.In SQL 2000 Data Transformation Services(DTS) is used as ETL tool where as in SQL 2005 SQL Server Integration Services(SSIS) is started used as ETL tool .
13.In SQL 2000 PIVOT and UNPIVOT functions are not available where as in SQL 2005 PIVOT and UNPIVOT functions are introduced.
14.In SQL 2000 bulk copy update is not possible where as in SQL 2005 bulk copy update is possible.
15.In SQL 2000 we can't encrypt the database where as in SQL 2005 we can encrypt the database.
No comments:
Post a Comment