Differences B/w Sql Server 2005 & Sql Server 2000 (According to MSBI)
2000
|
2005
|
1. DTS
File to
File
DB to
DB
DB to
File
(
,dts extension )
|
1 SSIS
(SQL Server Integration Services)
(extension
is .dtsx)
|
2 M AS
|
2 SSAS
|
3 No
Reporting
|
3 SSRS
|
4 No
Notifications
|
4 SSNS (
Notification Services)
But in
2008 removed
|
5 No XML
Data Services
|
5 XML
Data Services added
|
6 No MDX
& XMLA service
|
6 MDX
& XMLA introduced
|
Notification
Services means: like Sending an Email When SSIS execution is successful…etc
No comments:
Post a Comment