User Interface

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

MySQL Connectivity

MySQL Connectivity

  • 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

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

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

Database Synchronization

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
  • 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

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

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
  • Error and status logging

Database Explorer

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 Projects

Database Projects


Database Refactoring

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

T-SQL Debugger

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

T-SQL Debugger

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

Data Export and Import

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

Table Designer

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

User Interface

Integration with dotConnect for MySQL

  • Drag'n'drop objects onto form and dataset designers
  • Component editors extended with additional commands

Object Editor

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

Query Builder

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

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

Database Synchronization

Schema Comparison


SQL Editing and Execution

SQL Editing and Execution


Database Design

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