SQL Server Business Intelligence Features Comparison
SQL Server 2005 is a complete business intelligence system that provides the features, tools, and functionality to build both classic and innovative analytical applications.
The following table presents an overview of the components of a business intelligence system, and the corresponding Microsoft SQL Server 2000 and SQL Server 2005 components.
|
| 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 | Not applicable | SQL Server 2005 Reporting Services |
Ad hoc query and analysis | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal Server) | Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal Server) |
Database development tools | SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other tools | SQL Server 2005 Business Intelligence Development Studio (New) |
Database management tools | Enterprise Manager, Analysis Manager | SQL Server Management Studio (New) |
