A lot of questions had been asked in forums about the difference between SQL Server 2000 and 2005. Below is a table which shows the components of both versions:
Component | SQL Server 2000 | SQL Server 2005 |
---|---|---|
Extract, transformation, and load | Data Transformation Services (DTS) | SQL Server 2005 Integration Services |
Relational data warehouse | SQL Server 2000 relational database | SQL Server 2005 relational database |
Multidimensional database | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
Data mining | SQL Server 2000 Analysis Services | SQL Server 2005 Analysis Services |
Managed reporting | SQL Server 2000 Reporting Services | SQL Server 2005 Reporting Services |
Ad hoc reporting | | SQL Server 2005 Reporting Services |
Ad hoc query and analysis | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) |
Database development tools | SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other | SQL Server 2005 Business Intelligence Development Studio |
Database management tools | Enterprise Manager, Analysis Manager | SQL Server 2005 SQL Server Management Studio |