Friday, October 17, 2008

SQL Server 2000 vs. SQL Server 2005

1) The Data Transformation Service (DTS) system (sql server 2000) has been replaces by the SQL System Integration Service (SSIS) in sql server 2005.
2)The GUI management system is much more integrated now with the functionality of both Enterprise Manager and Query Analyser in the same application (SQL Server Management Studio).
3) Exception handling concept is new in sql server 2005. We can use Try Catch block to catch the exception. This feature is limited in sql server 2000 like @@error to show the error, no much flexibility..

No comments: