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 unicode databases (UTF-8)
• Support of SSL/SSH/HTTP connections
• Work with MySQL embedded server

Schema Object Management

• 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

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: MS Access, CSV, DBF, HTML, MS Excel,
  ODBC, PDF, RTF, Text, and XML
• Data import wizard
• Customizable data import from MS Access, CSV, DBF, MS Excel, ODBC, Text, and XML
  formats [New]
• Composing of data reports [New]
• Converting data into a pivot table [New]

Database Designer

• Visualization of tables, views, and stored routines
• 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 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

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 optimization of tables
• Server objects flush dialog
• Session manager
• Service control for starting and stopping MySQL servers
• Server Variables window

Schema Comparison and Synchronization

• Ability to compare a database with a database
• Ability to compare a database with a project
• Schema comparison reports generation. [New]
• Command line launch for schema comparison and synchronization. [New]
• Synchronization between different server versions
• Comparison results filtering
• Schema synchronization script generation
• Per object viewing of DDL differences
• Objects exclusion from synchronization
• Saving and loading of comparison settings

Data Comparison and Synchronization

• Comparison of large tables
• 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. [New]

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