User Interface

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

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

Administration and Maintenance

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

Integration with dotConnect for Oracle

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

Data Analysis

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

Data Comparison

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


Data Editor

Data Editor

  • 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

Database Explorer

Database Explorer

  • 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

Database Projects

Database Projects

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

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

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

Object Editor

Object Editors

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

Object Search

Object Search

  • Search in object names
  • Search in object DDL
  • Search in table data

Oracle Export and Import Utilities Support

Oracle Export and Import Utilities Support

  • Support for Exp and Imp utilities
  • Wizards for export and import procedure setup
  • Quick access from Database Explorer

Query Builder

Query Builder

  • 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

Query Profiler

Query Profiler

  • 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

Database Synchronization

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
  • Saving and loading comparison settings
  • Schema comparison reports generation

You can find the full feature list for schema comparison tool.


Schema Export and Import

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

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

Database Design

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