dbForge Fusion for MySQL Features

Integration with the most popular IDEs

  • 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 and Borland Delphi

Integration with dotConnect for MySQL and MyDAC

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

MySQL Connectivity

  • Multiple database connections in Database Explorer window
  • Asynchronous connect to server with cancel feature
  • Support of all MySQL server versions 3.23-6.0
  • Direct access to MySQL server without client libraries
  • Support of UTF-8 databases
  • Support of SSL/SSH/HTTP connections
  • Work with MySQL embedded server

Schema Object Management

  • Visual editors for tables, columns, indexes, foreign keys, and views
  • Partitioning support for a table editor
  • Visual editors for triggers, events, and user-defined functions
  • Combined editors for stored procedures and functions
  • Ability to browse schema objects in a single editor (pin document)
  • Duplicate object feature
  • Customizable DDL generation wizard
  • Schema object search based on a variety of parameters
  • Summary window for quick browsing of schema object properties
  • Data searching on a live database
  • Multi-selection in Database Explorer for batch operations on schema objects

Advanced SQL Editing

  • SQL editor with syntax coloring, bookmarks, and text searching
  • Code outlining with support of user-defined collapsing regions
  • Navigation bar for jumping between object definitions within one document
  • Document Outline window for quick navigation on large scripts
  • Code templates library
  • Quick access to favorite templates from SQL editor
  • Context-sensitive code completion
  • Parameter information for stored routines
  • Quick information about schema objects
  • One step access to a schema object editor from code (go to definition)
  • Automatic SQL syntax check
  • SQL formatting on-the-fly in editor
  • Wizard for batch SQL formatting of files on disk
  • Dynamic help on MySQL accessible from the editor

SQL Execution and Data Management

  • Execution of scripts, selected SQL fragments, and statements
  • Executed SQL history
  • Asynchronous execution with cancel feature
  • Execution plan tool
  • Transaction support
  • Data editor with in-place filtering, grouping, and sorting options
  • Paginal data access for large result sets
  • Graphical card view for data editor
  • Large objects (LOB) editor
  • Text search in data editor
  • Data printing
  • Data export wizard

Visual Query Builder

  • State-of-art diagram with zooming and keyboard support
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Copy/Paste for tables on a diagram
  • Expression builder for creating complex conditions
  • Undo/Redo support
  • Saving queries to a file

Stored Routine and Script Debugging

  • Support of procedures, functions and triggers
  • Single-click debug engine deployment
  • Step-by-step execution
  • Breakpoint management
  • Call stack navigation
  • Watches window for variable evaluation
  • Evaluate session variables when debugging a script

Server Administration and Maintenance

  • Security Manager to administer user accounts and privileges
  • Quick access to object privileges from Database Explorer
  • Schema export and import wizards
  • Table maintenance wizard
  • Server objects flush dialog
  • Session manager
  • Service control for starting and stopping MySQL servers
  • Server Variables window

Schema Comparison and Synchronization

  • Compare a database with a database
  • Compare a database with a project
  • Synchronization between different server versions
  • Comparison results filtering
  • Schema synchronization script generation
  • Per object viewing of DDL differences
  • Exclude objects from synchronization
  • Save and load comparison settings

Data Comparison and Synchronization

  • Comparison of large tables
  • Optional view comparison
  • Custom comparison keys support
  • Option for BLOB data comparison
  • Filtering of comparison results
  • Schema synchronization script generation
  • Per record viewing of data differences
  • Exclude tables and records from synchronization
  • Save and load comparison settings

Database Project

  • New project wizard with import from an existing database
  • Project Explorer window for managing project files
  • Object View window for browsing logical project structure
  • Export project files into one script
  • Reference checking on build
  • Multiple build configurations
  • Single-click project deployment on server
  • Database object refactoring
  • Schema comparison tool integration
  • Workspace saving

Customizable User Interface

  • Rich user settings
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Tool bars customization
  • Wizards for exporting/importing user settings
Order Download