Develop SQL and PL/SQL with Oracle Database and Oracle Autonomous Database. Oracle Developer Tools for Visual Studio (ODT) is a free extension for Microsoft Visual Studio.
Select your version of Visual Studio to download this extension:
Use Server Explorer with Visual Studio 2022, Visual Studio 2019, Visual Studio 2017 to browse your Oracle schema and launch one of the many integrated Oracle designers and wizards to create and alter schema objects.
View and Manage your Oracle Autonomous Databases from Server Explorer. You can quickly create Always Free Autonomous Database instances from Visual Studio, automatically download credentials files and be connected to the database to work on code within minutes. To learn more, view this step-by-step walkthrough.
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. Seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again.
View differences between two schemas and generate a diff script that can modify a target schema to match the source schema. Compare live database instances and/or an Oracle Database Project Version 2 containing a set of SQL scripts representing a schema.
Developers can easily and quickly create, clone, plug or unplug pluggable databases for use during development and testing.
Use Visual Studio's Entity Designer for Database First and Model First object-relational mapping. ("Code First" is also supported).
Use the Visual Studio Datasources Window, the Dataset Designer, and the TableAdapter Configuration Wizard to drag and drop and automatically generate .NET code.
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.
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.
Create, modify and administer your Queues and Queue Tables.
View UDTs in Server Explorer. Create UDTs in Oracle with multiple designers. A UDT Custom Class code generation wizard makes using UDTs from .NET code easy and fast.
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.
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.
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 adhoc SQL statements.
The integrated context sensitive online help, including the Oracle SQL and PL/SQL Users Guides puts the Oracle documentation at your fingertips. For information on how to install the documentation, please see the release notes.