dbForge Fusion for Oracle 关于

用于 Oracle 的 Visual Studio 插件。

dbForge Fusion for Oracle is a Visual Studio plugin designed to enhance productivity of Oracle database development and simplify data management processes. dbForge Fusion for Oracle allows developers to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different ways.

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 a single application.
  • Instant Client support.
  • Optional direct access mode for establishing connections without Oracle client software.
  • Work with Oracle on Amazon RDS.
  • Unicode support.

Administration Tools

  • 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.

Oracle Connectivity

  • Drag'n'drop objects onto form and dataset designers.
  • Component editors extended with additional commands.

Data Analysis

  • 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.

Database Synchronization

  • Compare and synchronize data in databases of virtually any size.
  • Compare 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.
  • Exclude tables and records from synchronization.
  • Save and load comparison settings.
  • Generate accurate comparison reports in HTML and Excel formats.

Data Editor

  • Asynchronous data fetch with the ability to cancel the operation.
  • Batch table update mode when changes are accumulated and applied explicitly.
  • Copy data with column headers for quick pasting to a 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 the data grid.
  • Large objects (LOB) editor.
  • Multi-table query result set editing.
  • Paginal data browsing for large result sets.
  • Print data.
  • Quick filter feature available for each data cell.
  • Record numbering option.
  • Read-only state indication.
  • Report, chart, and pivot building directly from the data editor.
  • Server-side sorting and filtering to help deal with large data sets.
  • Visible columns picking dialog box.
  • Edit multiple execution results of one script on separate tabs.
  • Support of various ADT in a separate editor.

Database Explorer

  • Multiple database connections allowed.
  • Asynchronous connecting to a server with the ability to cancel the operation.
  • Browse and navigate through objects.
  • Detailed object properties and data browsing in the 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 quickly sending 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.

Database Projects

  • New project wizard with import from an existing database.
  • Project Explorer window for managing project files.
  • Schema View window for browsing the logical project structure.
  • Project export into one of multiple scripts.
  • Multiple build configurations.
  • Single-click project deployment on the server.
  • Workspace saving.

PL/SQL Debugger

  • 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 and Import

  • CSV
  • XML
  • Text
  • XLS
  • PDF
  • DBF
  • HTML
  • RTF
  • MDB (Access)
  • ODBC
  • SQL

Object Editor

  • Create and manipulate database objects through a graphical interface.
  • Visual editors for several schema object types.
  • Undo option for object editor.
  • Ability to browse schema objects in a single editor (pin document).

Object Search

  • 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 the Database Explorer.

Query Builder

  • State-of-art diagram with zooming and keyboard support.
  • Preview and print the diagram.
  • Visually add 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.

Query Profiler

  • PL/SQL profiling to detect code performance bottlenecks.
  • Visual SQL explain plan.
  • Session statistics displayed in a UI.
  • A plan of the query is 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.

Schema Comparison

  • 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.
  • Save and load comparison settings.
  • Schema comparison reports generation.

Schema Export and Import

  • 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 the SQL editor.
  • Quick information about schema objects.
  • SQL editor with syntax coloring, bookmarks, and text search.
  • Executed SQL history window for the document.

Visual Database Designer

  • 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 the Document Outline window.
  • Diagram navigation with the Diagram Overview window.
  • Notes for adding comments to the diagram.