dbForge Studio for MySQL Feature List
Devart's MySQL GUI tool provides a number of instruments for server management and
administration. In this page you will find a comprehensive listing of features available
in dbForge Studio for MySQL. For a list of
dbForge Studio for MySQL 6.0 new features see What's New in
6.0.
Table of Contents
- Administration and Maintenance
- Data Analysis
- Data Comparison and Sync
- Data Editor
- Database Backup
- Database Explorer
- Database Refactoring
- Debugger
- Exporting and Importing Data
- Flat Table Editor
- MySQL Connectivity
- Object Editors
- Database Projects
- Query Builder
- Query Profiler
- Schema Comparison
- SQL Editing and Execution
- Visual Database Designer
- User Interface
Administration and Maintenance
- Comprehensive Security Manager
to administer user accounts and privileges
- Session manager for monitoring active MySQL server connections
- Service control for starting and stopping MySQL servers
- Table maintenance wizard for check, analysis, repair, and optimization of tables
- Server Variables window
- Server objects flush dialog
Data Analysis
- Master-detail data browser
- Data report generation wizard
- Data report designer
- Pivot table designer
- Chart building wizard
- Data search on a live database
- Automatic data report generation and delivery to the requested destination
Data Comparison and Sync
- Comparing and synchronizing data in databases of any size
- 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 interface for data comparison and synchronization
- Generating accurate comparison reports in HTML and Excel formats
- Comparison of custom query results (along with tables and views)
- Possibility to include objects into comparison by mask, which is useful when comparing
groups of tables
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 paste 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) through 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
Database Backup
- Comprehensive MySQL backup and restore wizards
- Schema or data only backups in addition to full backups
- Large database (exceeding 2 Gb) support
- Backup projects to save settings for future use
- Zip compression for backup files
- Command line support for scheduling backup tasks
- Error and status logging
Database Explorer
- Multiple database connections allowed
- Asynchronous connect to server with ability to cancel the operation
- 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
- Smart column renaming that allows rebuilding dependent tables
- Quick access to object privileges (GRANT) from the popup menu
- Multi-selection for batch operations on objects
- Database navigation history
Database Refactoring
- Renaming of tables, columns, views, procedures, and functions
- Preview of changes in the database with possibility to cancel them selectively
- Possibility to generate refactoring script of a database without changing it
- Refactoring feature can be accessed from Database Explorer and object editors
- Possibility to rename several columns from object editor
- If an error in processing dependencies is encountered, a user can fix it manually
Debugger
- Stored procedure and function
debugging
- Trigger 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
- Evaluation of session variables when debugging a script
- Single-click debug engine deployment
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
- Export data from command line interface
- Data import from:
- CSV
- XML
- Text
- XLS
- XLSX
- DBF
- MDB (Access)
- ODBC
- Import data from command line interface
- Templates for exporting and importing
Flat Table Editor
- Visual editor for tables
- Convenient editor for foreign keys
- Partitioning support
- Editable column grid: columns can be added and edited without
opening the popup dialog
- Full-text search on the column grid
- Schema changes can be viewed before updating database
- Heuristics helps define data type of new columns
MySQL Connectivity
- Support of all MySQL server versions 3.23-5.5
- Secure connections via SSL/SSH
- HTTP connections via PHP tunnel
- Support of UTF-8 databases
- Work with MySQL embedded server
- Direct access to MySQL server without client libraries
- Support of MySQL pluggable authentication when creating connection to MySQL server (PAM)
- Support of Windows authentication when creating connection to MySQL server
- Support of Amazon RDS
Object Editors
- Visual editors for columns, indexes, and views
- 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)
- Schema object search based on a variety of parameters
Database Projects
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
- Support of visual building of INSERT, UPDATE, and DELETE statements
- Conversion of SELECT queries into INSERT statements
- One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE
condition
Query Profiler
- SHOW PROFILE, EXPLAIN results and STATUS variables 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
Schema Comparison
SQL Editing and Execution
Visual 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
User Interface
- Start page providing easy access to main product features
- Rich user settings
- UI skins
- 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