dbForge Fusion for MySQL Features

Visual Query Profiler [New]

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a GUI
  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Capability to compare profiling results in two clicks
  • Capability to print profiling results

Visual Query Builder

Server Administration and Maintenance

  • Security Manager to administer user accounts and privileges
  • Quick access to object privileges from Database Explorer
  • Schema Backup and Restore wizards with support of command line
    interface, removing of old backups and multiple options [New]
  • Table maintenance wizard for check, analysis, repair, and optimization of tables
  • Server objects flush dialog
  • Session manager
  • Service control for starting and stopping MySQL servers
  • Server Variables window

Schema Object Management

  • Quick generating template SQL scripts for database objects [New]
  • Visual editors for tables, columns, indexes, and views
  • Convenient editor for foreign keys
  • Partitioning support in 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 search on a live database
  • Multi-selection in Database Explorer for batch operations on schema objects

Data Comparison and Synchronization

  • Comparing and sychronizing data in databases of any size [New]
  • Optional view comparison
  • 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
  • Saving and loading of comparison settings
  • Command line launch for data comparison and synchronization
  • Generating accurate comparison reports in HTML and Excel formats [New]

Schema Comparison and Synchronization

Advanced SQL Editing

SQL Execution and Data Management

  • Execution of scripts, selected SQL fragments, and statements
  • Execute Script Wizard for quick and convenient execution of large SQL scripts
  • 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
  • Ability to postpone sending of data updates to the server (Cached updates mode)
  • Data export wizard
  • Customizable data export to widely-used formats: CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML

Database Designer

  • Visualization of tables, views, and stored routines
  • Easy access to database objects to view and edit their properties, retrieve data, execute stored routines, etc
  • Support for IDEF1X and IE notations
  • Customizable diagram look and feel with skin support
  • Smart 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

Stored Routine and Script Debugging

Database Project

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 Embarcadero RAD Studio

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-5.1
  • Direct access to MySQL server without client libraries
  • Support of UTF-8 databases
  • Support of SSL/SSH/HTTP connections
  • Work with MySQL embedded server

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
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Wizard for exporting/importing user settings
Order Download