Integration with Visual Studio
-
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
- Support of Sphinx and Percona
-
Support of all MySQL server versions 3.23-5.x
-
Support of MariaDB
-
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
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
-
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
-
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
-
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
-
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
-
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
-
Error and status logging
-
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
-
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
-
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
MariaDB specific features
-
SELECT (LIMIT ROWS EXAMINED) extended syntax
-
INSTALL SONAME statement supported
-
SHOW EXPLAIN syntax
-
Multi-source replication syntax
-
Dynamic Columns syntax for DML statements
-
New KILL syntax
-
Expanded CREATE TABLE or ALTER TABLE syntax
-
Aria storage Engine supported
-
Virtual columns supported
-
Microseconds supported
-
Pluggable Authentication supported
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
-
Data import from:
-
CSV
-
XML
-
Text
-
XLS
-
XLSX
-
DBF
-
MDB (Access)
-
ODBC
-
Templates for exporting and importing
-
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
Integration with dotConnect for MySQL
-
Drag'n'drop objects onto form and dataset designers
-
Component editors extended with additional commands
-
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
-
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
-
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
SQL Editing and Execution
-
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
