Detailed Review of Two Best Visual Studio Plugins for Oracle Database

June 15th, 2021

The article deals with the Visual Studio add-ins for Oracle database development and management and provides an extensive comparison of two contenting add-ins for the aforesaid purpose, dbForge Fusion for Oracle and Oracle Tools for Visual Studio.

Why do Developers Need Plugins for Microsoft Visual Studio?

Perhaps there are no developers who are not familiar with Visual Studio that has proven to be a perfect IDE for developing almost anything, from a website to an application or a database.

Along with rich development-focused functionality, Visual Studio allows extending and custom-tailoring and the environment for the specific development needs with help of installing extensions s from Visual Studio Marketplace.

Oracle database development is no exception: it is hardly be imagined and, frankly speaking, possible without installing plugins into Visual Studio. In fact, you need one to establish a database connection.

As for the comprehensive development of oracle datasets, there is a number of extensions that can infuse Visual Studio with dozens of features for Oracle database development, administration, and management, this turning Visual Studio into the ultimate database development environment.

In this article, we will spot on the most notable plugins from the range, Oracle Developer Tools For Visual Studio and dbForge Fusion for Oracle.

Oracle Developer Tools for Visual Studio (ODT)

Oracle Developer Tools for Visual Studio is a free Visual Studio extension that allows developers to connect to Oracle databases, browse and modify Oracle schema objects and data, edit and debug PL/SQL, generate SQL scripts, and more.

The plugin functionality highlights include the following features for Oracle database development:

  • Support for Oracle Cloud
  • PL/SQL editor and debugger
  • SQL Script editing and execution
  • Oracle database projects
  • Schema comparison and sync
  • SQL testing and tuning

Devart dbForge Fusion for Oracle

dbForge Fusion for Oracle is a Visual Studio plugin designed to enhance the productivity of Oracle database development and simplify the data management process.

The plugin is compatible with the following Visual Studio versions:

  • Visual Studio 2019
  • Visual Studio 2017
  • Visual Studio 2015
  • Visual Studio 2013
  • Visual Studio 2012
  • Visual Studio 2010
  • Visual Studio 2008

dbForge Fusion for Oracle provides a really impressive pack of features, including:

  • PL/SQL code completion
  • Oracle PL/SQL debugger
  • Compare and sync both, schema and data
  • Oracle database designer
  • Query profiler
  • Oracle schema export/import

To learn more about the functionality of this Visual Studio plugin for Oracle DB development, refer to the Features product page.

Extensions Comparison Review

Since the general information about both plugins above does not say much to make a clear conclusion about them, we have carried a rigid comparison of each and every feature.

The table below represents the results of the comparison of features of dbForge Fusion for Oracle, Professional Edition with Oracle Developer Tools for Visual Studio 2019. For more convenience, we have grouped all the features into the following categories: Connectivity, SQL Development, Database Design, Database Administration, Data Pump, and Data Analysis.

Functionality dbForge Fusion for Oracle Oracle Developer Tools
Connectivity
Direct connection Yes Yes/No1
Connection (with Oracle Client) Yes No
Oracle 12c, 11g, 10g, 9i, 8i*, Oracle Express Edition (Oracle XE) 11 R2, 10 databases support Yes Yes
Oracle Cloud Infrastructure Application Deployment No Yes
Amazon RDS support Yes Yes
Exporting/importing user settings Exporting/importing user settings Yes No
SQL Development
PL/SQL editor with syntax highlight, bookmarks, and text search Yes Yes/No2
PL/SQL debugger Yes Yes/No3
PL/SQL formatter Yes No
Context-sensitive code completion Yes No
Quick information about schema objects Yes No
Parameter information for stored routines Yes No
Visual Query Builder Yes Yes/No4
Navigation to a schema object editor from code Yes No
Code snippets Yes No
Customizable DDL generation wizard Yes No
Query Profiler Yes No
Highlight Occurrences Yes No
Database Design
Visual editors for schema objects Yes Yes
Database projects Yes Yes
Schema comparison and synchronization tool Yes Yes
Database Diagrams Yes No
Find an object in a database Yes No
Object Viewer window Yes Yes
Dependencies lister Yes No
Database Administration
Database Administration Yes Yes
Security Manager Yes Yes
Session Manager Yes No
Event Monitor Yes No
Data Pump
Data comparison and synchronization tool Yes No
Data import and data export Yes Yes/No5
Schema export and import (dump) Yes No
Data Analysis
Pivot tables Yes No
Data reports Yes No
Master-Detail Browser Yes No
Find data record in a database Yes No
Data editor with in-place filtering, grouping, and sorting Yes No

1 Though Oracle Developer Tools provides a direct connection, some components will work in the limited functionality mode.
2 Oracle Developer Tools features merely basic SQ: Editor. The syntax highlight is limited to the keyword highlight.
3 Though the Oracle Developer Tools documentation states that the plugin includes the debugger feature, the internal Visual Studio debugger is used and does not allow debugging a PL/SQL query.
4 Oracle Developer Tools uses MS Query Designer.
5 Oracle Developer Tools allows importing tables (with/without data) only.

Conclusion

In this article, we took a rigid look at the two best Visual Studio add-ins for Oracle database development, Oracle Developer Tools and dbForge Fusion for Oracle, and handled out a detailed comparison of both tools.

A close look at the tools showed that Oracle Developer Tools suits best to perform merely simple database tasks, e.g. carry out minor database tweaks, perform a check the work that has been done already. Among the stand-outs of Oracle Developer Tools are support for Oracle Cloud and a handy database tree that neatly builds into Server Explorer.

As for full-featured database development, dbForge Fusion for Oracle seems to be a more suitable candidate. The plugin delivers really powerful functionality for every aspect of Oracle database development. To name a few, advanced SQL Development functionality with outstanding code completion, visual query builder, and query profiler; database diagram feature, import/export of both, schema and data, a full set of features for data analysis (data reports, master-detail browser, pivot tables), and much more.

If these Oracle developer tools sound good to you as well, we highly recommend downloading a 30-day free trial of dbForge Fusion for Oracle and check how it can move your Oracle database development further!

Leave a Comment