FeatureSQL Server 2005Oracle 10g R2 CLR Integration Integration with CLR Yes (In-process)Yes (out-of-process) Stored procedures in any .NET languageYesYes Triggers in any .NET languageYesNot Sure User-defined functions YesNot sure .NET objects stored inside the databaseYesNo Visual Studio Integration Can view database objects through Visual StudioYes (through Server Explorer)Yes (through Oracle Explorer) Ability to debug stored procedures through Visual StudioYesNo Support for Visual Studio ProjectYesNo Auto-deployment of database objects through Visual StudioYesNo Context-sensitive online help for editing stored procedures NoYes BI technologies integrated with Visual StudioYesNo SOA Application Development XML Support Native XML type in the databaseYesYes XQuery supportYesYes XML update functionsYesNo XML indexes for improved performanceYesNo (Text and Functional indexes only) Web Services Database as a Web service producerYes (built-in HTTP endpoint requires no additional Web server)Yes (requires extra-cost Oracle Application Server) Database as a Web service consumerYes (with .NET CLR integration)Yes (but requires extra-cost Oracle Application Server) Integration with Visual StudioYesNo Primary programming languageAny CLR languageJava Asynchronous Message Queuing Product nameSQL Server Service BrokerOracle Advanced Queuing Guaranteed, exactly once delivery YesYes Queues stored in databaseYesYes Transactional integration with database YesYes Publish-Subscribe communication modelNo (point-to-point only)Yes Abstraction levelQueues, messagesServices, Dialogs, Contracts Query Notification Query Notification through ADO.NETYesNo (Equivalent functionality requires Oracle Web Cache and Oracle Java Object Cache; these are features of the Oracle Application Server Product) |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 13:20 , Processed in 0.170799 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.