Log In
or
Register
Products
News
Forums
Blogs
Company
Shopping cart
Home page
Home
/
Products
/
Database Tools
/
MySQL
/
Studio
/
Features
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
In this section
Overview
What's New in 4.00
Benefits
Editions
Features
Product History
Screenshots
System Requirements
Download
Ordering
Support
Articles
Blog
Testimonials
"Very excited to try the new 4.0 release! From the release notes it looks as almost all of the things I've been waiting for have been included. Most importantly, it looks as if the ability to select a database for easy query execution (so I don't have create a USE clause), as well as a new way to execute stored procedures is in---excellent news!
It's those little things that make my time with SQL easier."
Matthew Grdinic,
owner of nicSoft (web software company)
Read more
Your testimonial
You might be also interested in:
Database tools:
dbForge for MySQL
,
dbForge for SQL Server
,
Database tools for Oracle
MySQL data access with the following technologies:
ADO.NET provider
,
VCL components
,
dbExpress driver