dbForge Studio for MySQL Feature List
This page provides a comprehensive listing of features available in dbForge Studio for MySQL.
For a list of dbForge Studio for MySQL 5.0 new features see What's New in 5.0.
Table of Contents
- Administration and Maintenance
- Backup
- Data Analysis
- Data Comparison
- Data Editor
- Database Explorer
- Debugger
- Exporting and Importing Data
- MySQL Connectivity
- Object Editors
- 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
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
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
Data Comparison ↑
- 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
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 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
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
- 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
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
Object Editors ↑
- 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)
- Schema object search based on a variety of parameters
Projects ↑
Query Builder ↑
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