Oracle Developer Tools for Visual Studio

The Oracle Developer Tools for Visual Studio (ODT) is a tightly integrated "Add-in" for Microsoft Visual Studio. ODT is free and the new 12.1.0.1.2 release now adds support for Visual Studio 2013 

 

  • Integration with Visual Studio: Use Server Explorer with Visual Studio 2013, Visual Studio 2012 or Visual Studio 2010 to browse your Oracle schema and launch one of the many integrated Oracle designers and wizards to create and alter schema objects. Use Microsoft Query Designer to visually design queries.
  • New Schema Compare Tools: New! View differences between two schemas and generate a diff script that can modify a target schema to match the source schema. A great tool for deployment!
  • Multitenant Container Database Administration Features: New! Developers using Oracle Database 12c can easily and quickly create, clone, plug or unplug pluggable databases for use during development and testing.
  • Entity Framework Designers and Wizards: Now supports Fully Managed ODP.NET! Use Visual Studio's Entity Designer for Database First and Model First object-relational mapping
  • Automatic .NET Code Generation: Now supports Fully Managed ODP.NET! Use the Visual Studio Datasources Window, the Dataset Designer, and the TableAdapter Configuration Wizard to drag and drop and automatically generate .NET code.
  • Easy ASP.NET Web Development: If you're an ASP.NET web developer, ODT makes it easy to generate ASP.NET web applications with minimal coding required.
  • Powerful Application Tuning Tools: Use Oracle Performance Analyzer to tune your .NET application's use of Oracle Database via a single click of a button. The database is then monitored under load and recommendations are made, such as modifications to SQL or adding an index on a table. You can also tune Ad-hoc SQL statements in Query Window with SQL Tuning Advisor.
  • SQL Script Lifecycle with Source Control Integration: Generate SQL scripts for Oracle schema objects that your .NET application uses, manage them in an Oracle Database Project, check them into source control, edit the scripts in the Oracle SQL Editor, and execute them with a built in SQL*Plus execution engine.
  • PL/SQL Editor and Debugger: The fully integrated PL/SQL Editor and Debugger allows you to leverage all of your favorite Visual Studio debugging features from within PL/SQL code. You can even seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again!
  • NET Stored Procedure Deployment: The .NET Deployment Wizard makes it easy to deploy .NET stored procedures and functions into Oracle Database.
  • Integrated Online Help System: The integrated context sensitive online help, including the Oracle SQL and PL/SQL Users Guides puts the Oracle documentation at your fingertips.
  • Manage Users, Roles and Privileges: New! Create Users and Roles using graphical designers. Assign privileges to the roles and assign roles to users. View the Users and Roles in Server Explorer.
  • Oracle Advanced Queuing (AQ) Designers: New! Create, modify and administer your Queues and Queue Tables.
  • User-Defined Types (UDTs): Create UDTs in Oracle with multiple new designers. A powerful UDT Custom Class code generation wizard makes using UDTs from .NET code easy and fast.
  • Import Table Wizard: This wizard makes it easy to import tables and their data from Oracle databases, or from external datasources such as Microsoft SQL Server, Microsoft Access and Excel spreadsheets.
  • Data Editing, Stored Procedure Testing, Adhoc SQL Execution: When testing your .NET application you can use the Oracle Data Window to insert and update Oracle data. There's also a testbed for testing stored procedures and an Oracle Query Window for executing any SQL statement you choose.

Download:
 Download ODT 12.1.0.1.2 New! (List of new features by version)

Watch Video Demonstrations:
 Introduction to ODT with Visual Studio 2012

Guided Walkthroughs:
 Oracle by Example: Using Multitenant Container Databases in Visual Studio New!
 Oracle by Example: Using Schema Compare in Visual Studio 2012 New!
 Oracle by Example: SQL Tuning Advisor and Oracle Performance Analyzer
 Oracle by Example: Building ASP.NET Web Applications with ODT
 Oracle by Example: Building .NET Applications Using ODT
 Oracle by Example: Debugging Oracle PL/SQL from Visual Studio
 Oracle by Example: Using Oracle User-Defined Types with .NET and Visual Studio

Read:
 Oracle Magazine: Write Messaging Applications with ODP.NET and Oracle Streams Advanced Queuing.
 Oracle Magazine: Use Visual Studio for the Complete .NET and Oracle Database Development Lifecycle
 Oracle Magazine: Build Applications with ODT and Oracle User-Defined Types
 ODT FAQ: Answers to Common OTN Discussion Forum Questions

 

Additional Information
 Oracle Openworld 2013 .NET Slidedecks Oct 2013
 Blog: Debugging PL/SQL from ASP.NET and Visual Studio Oct 2006
 Oracle Magazine: Debugging PL/SQL from .NET Sept 2006
 Oracle Magazine: Tools for Your .NET Space (with PL/SQL debugging) June 2006

 

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Left Curve
Popular Downloads
Right Curve
Untitled Document