Feature
SQL Server 2005
Oracle 10g R2
CLR Integration
Integration with CLR
Yes
(In-process)
Yes
(out-of-process)
Stored procedures in any .Net language
Yes
Yes
Triggers in any .Net language
Yes
Not Sure
User-defined functions
Yes
Not sure
.Net objects stored inside the database
Yes
No
Visual Studio Integration
Can vIEw database objects through Visual Studio
Yes
(through Server Explorer)
Yes
(through Oracle Explorer)
Ability to debug stored procedures through Visual Studio
Yes
No
Support for Visual Studio Project
Yes
No
Auto-deployment of database objects through Visual Studio
Yes
No
Context-sensitive online help for editing stored procedures
No
Yes
BI technologIEs integrated with Visual Studio
Yes
No
SOA Application Development
XML Support
Native XML type in the database
Yes
Yes
XQuery support
Yes
Yes
XML update functions
Yes
No
XML indexes for improved performance
Yes
No
(Text and Functional indexes only)
Web Services
Database as a Web service producer
Yes (built-in HTTP endpoint requires no additional Web server)
Yes (requires extra-cost Oracle Application Server)
Database as a Web service consumer
Yes (with .Net CLR integration)
Yes (but requires extra-cost Oracle Application Server)
Integration with Visual Studio
Yes
No
Primary programming language
Any CLR language
Java
Asynchronous Message Queuing
Product name
SQL Server Service Broker
Oracle Advanced Queuing
Guaranteed, exactly once delivery
YesYes
Queues stored in database
Yes
Yes
Transactional integration with database
Yes
Yes
Publish-Subscribe communication model
No (point-to-point only)
Yes
Abstraction level
Queues, messages
Services, Dialogs, Contracts
Query Notification
Query Notification through ADO.Net
Yes
No
(Equivalent functionality requires Oracle Web Cache and Oracle Java Object Cache; these are features of the Oracle Application Server Product)
轉自：動態網站制作指南 | www.knowsky.com
