Welcome to Oracle Developer Tools for Visual Studio

Oracle Developer Tools for Visual Studio 2022 is a free Visual Studio extension that makes it easy to connect to your Oracle Database and Oracle Autonomous Database, browse and modify schema objects and data, edit and debug PL/SQL, generate SQL deployment scripts, perform schema comparisons, tune SQL and .NET app performance, and more. Use Oracle Cloud Explorer to create an Always Free Oracle Autonomous Database instance in the cloud and begin developing your database app quickly.

These tools are a required component to enable development with Entity Designer and Table Adapter Configuration Wizard.

Before you begin, read the following sections to learn about how best to get started using Oracle Developer Tools:

Oracle Developer Tools Functionality

Oracle Developer Tools provides the following functionality:

Server Explorer Integration: The Server Explorer Window is a component of Visual Studio that consists of a tree control that allows you to browse data connections and servers. Oracle Developer Tools for Visual Studio integrates with Server Explorer and allows you to browse Oracle Database and also to manage and browse your Oracle Autonomous Databases.

To display Server Explorer, select Server Explorer from the Visual Studio View menu.
Wizards, Designers, and Dialogs help you easily create new schema objects or alter existing schema objects. You launch the wizards and designers from the menus that display when you right-click nodes in Server Explorer.
Oracle Data Window displays table and view data in a grid format, which you can view or update. To launch Data Window, double-click the node representing the table or view whose data you want to view or update.
Oracle Query Window lets you enter, execute, and view the results of SQL and PL/SQL statements in a window and perform an Explain Plan on a query.
About PL/SQL Code Editor is a database-backed editor (not a file-based editor) that provides syntax coloring, automatic formatting, statement completion, method tips, error task items, and collapsible regions as you work. To start PL/SQL Code Editor, double-click the node for the PL/SQL schema object whose code you want to edit.

For a file-based editor for Oracle SQL and PL/SQL scripts, see Oracle SQL Script Editor.
Oracle PL/SQL Debugger enables you to debug PL/SQL programs in the Visual Studio environment, in much the same manner as you would debug a C# or Visual Basic .NET program.
Oracle Database Project Version 2 is a Visual Studio project type that enables you to manage SQL scripts, providing the ability to edit and run them, as well as checking them into source control.

Get Help, Provide Feedback, and Report Issues

Questions or feedback about this extension? Please post your questions, comments, or report issues on the Oracle Developer Tools forum.