All-in Oracle Tools for Visual Studio
dbForge Fusion for Oracle is designed to broaden the functionality of Visual Studio with
powerful PL/SQL developer tools for management and administration of Oracle databases. This page features a
comprehensive listing of features available in dbForge Fusion for Oracle. For a
list of new features, see What's New in 3.6.
Table of Contents
-
Integration with Visual Studio
-
Oracle Database Connectivity
-
Administration Tools
-
Integration with dotConnect for Oracle
-
Data Analysis
-
Data Comparison
-
Data Editor
-
Database Explorer
-
Database Projects
-
Debugger
-
Exporting and Importing Data
-
Object Editors
-
Object Search
-
Oracle Export and Import Utilities Support
-
Query Builder
-
Query Profiler
-
Schema Comparison
-
Schema Export and Import
-
SQL Editing and Execution
-
Visual Database Designer
Integration with Visual Studio
-
All database development and administration tasks available from your IDE
-
SQL Editor, database object editors and other editors behave like usual IDE documents
-
Help integrated into Microsoft Visual Studio .Net
Oracle Database Connectivity
-
Support for Oracle versions from 8i to 12c
-
Ability to use several Oracle Homes in single application
-
Instant Client support
-
Optional direct access mode for establishing connections without Oracle client software
-
Working with Oracle on Amazon RDS
-
Unicode support
-
Comprehensive Security Manager to administer user accounts and privileges
-
Session manager for monitoring active Oracle server connections and tracing user
sessions
-
Event Monitor for monitoring Oracle database alerts and pipe messages
Integration with dotConnect for Oracle
-
Drag'n'drop objects onto form and dataset designers
-
Component editors extended with additional commands
-
Display table data representing Parent-Child dependencies (Master-Detail Browser)
-
Data report generation wizard
-
Data report builder
-
Pivot table designer
-
Chart building wizard
-
Data search on a live database
-
Automate report generation and distribution
-
Comparing and synchronizing data in databases
of virtually any size
-
Comparison of tables, views, materialized views, and custom queries
-
Custom comparison keys support
-
Option for BLOB data comparison
-
Comparison results filtering
-
Data synchronization script generation
-
Per record viewing of data differences
-
Excluding tables and records from synchronization
-
Saving and loading of comparison settings
-
Generating accurate comparison reports in HTML and Excel formats
You can learn the full
feature list
for data comparison tool
.
-
Asynchronous data fetch with ability to cancel the operation
-
Batch table update mode when changes are accumulated and applied explicitly
-
Copying data with column headers for quick pasting to spreadsheet
-
Custom data filters of any complexity
-
Data Viewer window for browsing images, rtf, and binary cell values
-
Date time editor with visual interface
-
Foreign key lookup editor for easy editing of fields referencing other tables
-
Free copying of any block of data to clipboard
-
Full-text search (Ctrl+F) in data grid
-
Graphical card view
-
Grouping by arbitrary columns
-
Incremental search (Ctrl+I) through data grid
-
Large objects (LOB) editor
-
Multi-table query result set editing
-
Paginal data browsing for large result sets
-
Printing of data
-
Quick filter feature available for each data cell
-
Record numbering option
-
Read-only state indication
-
Report, chart, and pivot building directly from data editor
-
Server-side sorting and filtering to help dealing with large data sets
-
Visible columns picking dialog box
-
Editing of multiple execution results of one script on separate tabs
-
Support of various ADT in a separate editor
-
Multiple database connections allowed
-
Asynchronous connecting to server with ability to cancel the operation
-
Browse and navigate through objects
-
Detailed object properties and data browsing in Object Viewer window
-
Dependency tree browsing for each object
-
Duplicate object feature
-
Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc.
-
Customizable DDL generation via wizard
-
'Send To' command for quick sending of tables to Query Builder, Data Report, and
other tools
-
Quick access to object privileges (GRANT) from the popup menu
-
Multi-selection for batch operations on objects
-
Database navigation history
-
New project wizard with import from an existing database
-
Project Explorer window for managing project files
-
Schema View window for browsing logical project structure
-
Project export into one of multiple scripts
-
Multiple build configurations
-
Single-click project deployment on the server
-
Workspace saving
-
PL/SQL code debugging
-
Script debugging
-
Step Into, Step Over, and Step Out commands for step-by-step execution
-
Breakpoints support for procedures, functions, triggers, and scripts
-
Breakpoints window
-
Call Stack window with navigation
-
Watches window for variable evaluation
Exporting and Importing Data
-
Data export to:
-
CSV
-
XML
-
Text
-
XLS
-
PDF
-
DBF
-
HTML
-
RTF
-
MDB (Access)
-
ODBC
-
SQL
-
Export data from multiple tables at once
-
Data import from:
-
CSV
-
XML
-
Text
-
XLS
-
XLSX
-
DBF
-
MDB (Access)
-
ODBC
-
Templates for exporting and importing
-
Create and manipulate database objects through graphical interface
-
Visual editors for following schema
object
types:
-
Database link
-
Cluster
-
Check constraint
-
Foreign key
-
Index
-
Materialized view
-
Materialized view log
-
Package
-
Sequence
-
Stored function
-
Stored procedure
-
Synonym
-
Table
-
Trigger
-
Unique key
-
User type
-
View
-
XML schema
-
Undo option for object editor
-
Ability to browse schema objects in a single editor (pin document)
-
Search in object names
-
Search in object DDL
-
Search in table data
Oracle Export and Import Utilities Support
-
Support for Exp and Imp utilities
-
Wizards for export and import procedure setup
-
Quick access from Database Explorer
-
The state-of-art diagram with zooming and keyboard support
-
Preview and printing of the diagram
-
Visual addition of sub-queries
to any part of the main query
-
Query outline (displayed in Document Outline window)
-
Visual editing of sub-queries
-
Expression builder for creating complex conditions
-
Copy/Paste for tables on the diagram
-
Undo/Redo support
-
Saving queries to a file
-
PL/SQL profiling to detect code performance bottlenecks
-
Visual SQL explain plan
-
Session statistics displayed in a UI
-
Plan of the query displayed in the tree view for easy review
-
Profiling history
that can be saved for further analysis
-
Compare profiling results feature with differences highlight
-
Profiling results printing
-
Option to
compare and synchronize Oracle database schemas
-
Synchronization between different server versions
-
Compare schemas using live connections or pre-saved offline snapshots
-
Compare and generate database server change scripts between two or more databases
-
Schema synchronization script generation
-
Per object viewing of DDL differences
-
Objects exclusion from synchronization
-
Comparison results filtering
-
Saving and loading comparison settings
-
Schema comparison reports generation
You can find the full
feature list for schema comparison tool.
-
Comprehensive
Oracle database
schema export and import
wizards
-
Export of Oracle object definition schemas as well as its data
-
Large Oracle schema export support
-
Reverse engineer objects DDL including roles, permissions to recreate objects in
a different db/schema
-
Schema export projects to save settings for future use
-
Zip compression for export output files
-
Error and status logging
SQL Editing and Execution
-
Code collapsing/expanding with support of user-defined regions
-
Code snippets library with a browser window and editor
-
Context-sensitive code completion
-
PL/SQL formatter
-
Document Outline window for quick navigation through large scripts
-
Execution of scripts, selected SQL fragments, and statements
-
Store PL/SQL execution parameters for re-use
-
One-step access to a schema object editor from code (go to definition)
-
Parameter information for stored routines
-
Quick access to favorite templates from SQL editor
-
Quick information about schema objects
-
SQL editor with syntax coloring, bookmarks, and text search
-
Executed SQL history window for the document
-
Visualization of tables,
views, stored procedures
-
Easy access to database objects for viewing their properties, editing, retrieving
data, executing stored routines, etc.
-
Support for IDEF1X and IE notations
-
Customizable diagram look and feel with skin support
-
Smart ER Diagram layout
-
Diagram export to different image formats
-
Searching database objects on diagram
-
Organizing diagram shapes with containers
-
Customizable diagram printing with a rich set of options
-
Optional displaying of table constraints, indexes, and triggers
-
Integration with Document Outline window
-
Diagram navigation with Diagram Overview window
-
Notes for adding your comments to the diagram