Comparing sql server 2005 and oracle 10g

[pic]

Comparing SQL Server 2005 and Oracle 10g as a Database Platform for Microsoft .NET Developers

A Comparison of Developer Productivity

Author: Mitch Ruebush
Published: April 2005
Summary: This paper compares SQL Server 2005 and Oracle 10g from the perspective of the Visual Studio® developer. The focus is on answering the question: “Which of the two databases is a more productiveapplication development platform for the .NET platform developer?”
Audience: The paper is targeted toward technology decision makers as well as information technology managers, architects, and database application developers.

Copyright

This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.
The information containedin this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This White Paper is forinformational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic,mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this documentdoes not give you any license to these patents, trademarks, copyrights, or other intellectual property.
© 2005 Microsoft Corporation. All rights reserved.
Microsoft, IntelliSense, Visual Basic, Visual Studio, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
The names of actual companies and products mentionedherein may be the trademarks of their respective owners.

Contents

A Comparison of Developer Productivity 1
Introduction 1
Basis for Comparison 1
Integration with Visual Studio and the Microsoft .NET Platform 1
SOA-based application development 2
Deployment flexibility 2
Summary of Results 3
Visual Studio and .NET CLR Integration 3
Visual Studio integration3
.NET integration 4
SOA Application Development 4
Deployment Flexibility 5
Integration with the Microsoft .NET Common Language Runtime 5
In-Process versus Out-of-Process Hosting 6
CLR 1.1 versus CLR 2.0 6
Database Object Types Supported 6
Storage of .NET Assemblies 6
Visual Studio Integration 6
SQL Server 2005 and Visual Studio 2005 7
Server Explorer 7ADO.NET programming 9
Query Designer 9
Debugging stored procedures 10
SQL Server projects 11
Integration of BI technologies 13
SQL Server Analysis Service 13
SQL Server 2005 Reporting Services 14
SQL Server Integration Services 15
Visual Studio Integration with Oracle 16
Oracle Explorer 16
Project support 18Debugging stored procedures 18
Integration of BI components 19
Integration with Visual Studio: Summary 19
SOA-Based Application Development 19
Comparison of XML Support 19
Native XML Type and XQuery 19
Indexing 20
Updating XML 20
XML schema collections and schema evolution 20
Comparison of Web Services Support 21
SQL Server 2005 21
Oracle...