dbForge Studio for MySQL Features

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 search 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 through large scripts
  • Code templates library with a browser window
  • 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 the editor
  • Wizard for batch SQL formatting of files on the 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
  • 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

Visual Query Builder

  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Copy/Paste for tables on the 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
  • Evaluation of 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 for check, analysis, repair, and optimisation of tables
  • Server objects flush dialog
  • Session manager
  • Service control for starting and stopping MySQL servers
  • Server Variables window

Schema Comparison

  • Ability to compare a database with a database
  • Ability to compare a database with a project
  • Synchronization between different server versions
  • Comparison results filtering
  • Schema synchronization script generation
  • Per object viewing of DDL differences
  • Objects exclusion from synchronization
  • Save and load comparison settings

Data Comparison

  • Comparison of large tables
  • Optional view comparison
  • Custom comparison keys support
  • Option for BLOB data comparison
  • Comparison results filtering
  • 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
  • Project export into one script
  • Reference checking while building
  • Multiple build configurations
  • Single-click project deployment on the 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
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Wizard for exporting/importing user settings
Order Download