Full Visual Studio & Oracle Integration
dbForge Fusion for Oracle is a plugin for Visual Studio designed to enhance the productivity of Oracle database development and simplify data management.
Connect Compatibility with Different Oracle Versions
The Visual Studio extension supports Oracle Server versions from 8i to 12c R1. As to the connectivity support, dbForge Fusion for Visual Studio 2017/2019 is compatible with Oracle versions from 12c R2 to 19c.
Oracle Database Administration Tools
Take advantage of using our powerful database administration tools for Oracle: Security Manager, Session Manager, and Event Monitor that help DBAs effectively manage daily routine database administration tasks with the least utilization of resources and keep track of query performance.
Easy Connection with dotConnect for Oracle
dotConnect for Oracle is a high-performance ORM enabled data provider for Oracle that builds on ADO.NET technology to present a complete solution for developing Oracle-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.
Visual Data Analyzer
Professional reporting tools and Pivot functionality are perfect for summarizing and analyzing volumes of data in your database. To make your everyday work even easier, make report generation and distribution automatic.
Visual Data Comparison Functionality
Use Data Comparison Wizard any time you want to compare data in two Oracle tables. The data comparison and synchronization tool is available in all the editions of dbForge Studio for Oracle
Oracle Database Data Editor
The Data Editor allows you to view and quickly edit data right in the grid:
- asynchronous data fetch with the ability to cancel the operation
- batch table update mode to accumulate and apply changes
- Data Viewer window for browsing images, .rtf, and binary cell values
Oracle Database & Server Explorer
Database Explorer allows connecting multiple databases, browsing and navigating through objects, customizing DDL generation via wizard, generating quick template script for a selected object: SELECT, INSERT, EXECUTE, etc.
Visual Studio Oracle Database Project
Create, save, open database projects, and import database objects into them.
PL/SQL Debugger
With Oracle PL/SQL Debugger, you can easily control the flow of the debugging process. The tool helps identify and eliminate runtime code bugs, and prevents developers from complicated and error-prone application development.
Exporting and Importing Data
dbForge Fusion for Oracle provides the Data Import and Export wizards that help you manipulate data in a variety of popular formats, as well as create import/export templates for future use.
Visual Studio Object Editor
dbForge Studio for Oracle provides an opportunity to create and edit objects using visual objects editors. So there is no need to type SQL code to create or edit database objects in Oracle as this can be done simply from the context menu of the corresponding object (node) in Database Explorer.
Handy Search for Object in Oracle Database
The Find Object functionality can help you search through object names, object DDLs, and table data.
PL/SQL Query Builder
Query Builder is designed to enhance productivity and simplify SQL query building tasks. Query Builder provides a graphical user interface for creating SQL queries. You can drag-and-drop multiple tables, views and their columns onto a visual designer to generate SQL statements.
More on PL/SQL Query BuilderPL/SQL Query Profiler
The Query Profiler functionality helps you measure and optimize query performance in Oracle databases by using the EXPLAIN plan, analyzing query profiling results, and collecting session statistics.
Oracle Schema Compare in Visual Studio
The solution provides functionality that lets you visually detect differences and set up a safe and accurate database schema synchronization without data loss. You will be able to save time and perform the sync operation automatically.
Schema Export and Import
The Import and Export functionality helps you effectively back up and restore schema objects between Oracle databases using its schema export/import wizards, Oracle export/import utilities, or command-line interface.
SQL Editing and Execution
Almost any time you interact with a database you are writing and executing SQL queries. Taking this into account, SQL document is an essential part of every tool in dbForge product line. This is where you create SQL statements in order to run them against a DB server.
Visual Studio Database Designer
Oracle Database Designer allows you to build a clear and effective relational model of an Oracle database visually and to see the complete picture of all tables, foreign key relations between them, views, and stored routines of your database.