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
- 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
- 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
- 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
-
Data export to:
- CSV
- XML
- Text
- XLS
- 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
- 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
- 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