dbForge Studio for MySQL History
19-Apr-11 Release of dbForge Studio 5.00
See the hightlights of dbForge Studio 5.00 in What's New
section.
21-Jun-10 Release of dbForge Studio 4.50
Extended Express Edition
The following tools are added:
-
Session Manager
-
Server Variables
-
Table Maintenance Wizard
-
Flush dialog box
-
Database Backup Wizard with some limitations. It does not support command line,
backup projects, autodelition of old backup files, compression, and bakup files
larger than 1 MB.
-
Database Restore Wizard
Besides, Database Designer now supports 10 tables and Query Builder can work with
3 tables.
Redesigned Database Backup Wizard
Schema Export wizard has been totally redesigned to provide more freedom for backing
up schemas. It features the following:
-
Capability to save backup options for future use
-
Support of command line interface. You can back up schemas in automatic mode using
Windows task scheduler
-
Automatic archiving of schema backup scripts
-
Writing a report about backup process into a log file
-
Automatic removing old backup files based on date or quantity
New tool for database developers - Query Profiler
dbForge Studio offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN
in a convenient and clear GUI. Besides, you get STATUS variables for the required
query automatically calculated.
Additional benefits:
-
Plan of the query displayed in the tree view for easy review
-
Profiling history that can be saved for further analysis
-
Capability to compare profiling results in two clicks
-
Capability to print profiling results
Revised Data Comparison tool
Diverse testing and close interaction with database developers, admins and casual
users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now
it embraces the following:
-
Capability to compare and synchronize database of any size
-
Increased performance of comparison processes
-
Generating accurate comparison reports in HTML and Excel formats
-
Capability to change synchronization direction in one click
-
New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float
types
-
Quick filtering tables in comparison results
-
Optimized object management during custom synchronization
-
Capability to edit values of default comparison options
-
New synchronization option Exclude Comments
Improved Query Builder tool
Meet a stronger Query Builder tailored for creating complex conditions with several
clicks. The new power is based on the following:
-
Optimized performance of the Selection tab in the expression editor
-
New Wrap to Subquery option to wrap tables into a subquery
-
Visual addition of subqueries to any part of the main query
-
Optimized navigation in the editor, particularly between subqueries
-
Capability to edit view location in the query document
-
Joins show connection direction; better described connection properties
-
New skin for objects on the diagram
Quick generating template SQL scripts for database objects
Thanks to this new functionality, you can save your time while working with database
objects. For example, you can quickly generate template SQL scripts CREATE, DROP,
SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in
the context menu and called ‘Create Script As’.
A few improvements in Schema Comparison tool
-
Extended capabilities of Schema Comparison wizard
-
New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions,
default values for columns
Other improvements
-
New SQL document view layout - now you can see query text and retrieved data at
the same time
-
Generate DDL wizard was renamed into Generate Schema Script
10-Feb-10 Release of dbForge Studio 4.00
Data Import
Guided by a click-and-pick wizard, the users can easily import data from seven widely-popular
formats (CSV, DBF, MS Access, MS Excel, ODBC, Text, XML) with a multitude of settings
to meticulously tune the data.
Improved Data Editor
Up to 40 improvements were implemented to create quicker, easier, and more delighted
ways for data management. The Data Editor spares tens of mouse clicks a day for
you saying nothing of tens of frowns.
Pivot Grid
The users can convert large amounts of data into compact and informative summaries
- pivot tables. They can rearrange any obscure data by a simple drag of a mouse
to get the layout best for understanding data relations and dependencies.
Data Reports
Every user can benefit from a modern way of generating reports. Less time and manual
work is required — from getting required data from a database, analyzing,
to printing it as a smart, clear, and stylish report tuned for each particular case.
Virtual Relations on Database Diagram
Besides physically existing foreign key relations, dbForge Studio for MySQL allows
creating virtual relations. They help create relations between those tables which
storage engine do not support foreign keys. Later virtual relations can be easily
converted into physical foreign keys.
Command Line Launch for Data and Schema Synchronization Tools
This gives more freedom for the users who perform repeated synchronizations. It
takes only to set a desired time to launch the process and then come back to check
the desired result at a proper time.
Schema Comparison Reports
Keeping records of schema changes is now automated. dbForge Studio for MySQL can
generate a clear and attractive comparison reports upon the comparison completion.
Improvements to Better Serve Specific Users' Needs
The new version contains many essential improvements that increase the efficiency
in working with data. Here are some of them: addition of active database selector
to SQL Document, SQL formatting improvements, redesign of stored procedure/function
editor and SQL execution parameter editor.
12-Aug-09 Release of dbForge Studio 3.60
Unlimited database connectivity
It is good news for web developers working with remote databases, as employment
of remote connections becomes as simple as local ones. dbForge Studio v 3.60 offers
totally redesigned HTTP tunneling with simple tunneling script uploading to the
web site. No need to remember multi-step procedures using other tools. To provide
more flexibility while using SSH connection, public key authentication is supported.
Higher performance on large databases
Having passed multiple performance tests on large databases with all database objects,
including hundreds of tables, thousands of records, possessing various data types,
dbForge Studio for MySQL v 3.60 proved marked performance improvement as compared
with the previous version and beneficial leading among competitive programs.
The results of performance tests show that dbForge Studio for MySQL v 3.60 combines
high performance with accuracy and correctness to ensure high quality and efficient
database management. For example, dbForge Studio v 3.60 has 3 times faster data
comparison and 4 times faster schema export compared to the previous versions.
One more improvement is asynchronous execution of stored procedure. It is a great
benefit when working with slow procedures.
Optimized database connectivity
In contrast to the prior version dbForge Studio v 3.60 reduced network traffic up
to several times for performing such common tasks as opening connections, managing
database objects, performing schema and data export, retrieving data from tables,
executing procedures or stopping the execution. This optimization makes possible
to use dbForge Studio v 3.60 in cases of traffic limitations.
24-Apr-09 Release of dbForge Studio 3.50
A new excellent database diagram
The new version includes the best visual online database design tool for MySQL -
Database Designer. It is indispensable for anyone who needs to build a clear and
effective database structure visually and get the complete picture representing
all the tables, foreign key relations between them, views, and stored routines of
the required database.
It streamlines access to the database objects for viewing their properties, editing,
retrieving data, and executing stored routines. The database diagram enables reverse
engineering of databases to IDEF1X or IE diagrams, which can be easily printed.
You can see and use Database Designer in all dbForge Studio's editions. The number
of database objects, supported by Database Designer, in the free Express edition
is limited to 5 and in the Standard edition is limited to 20. The Professional edition
contains the unlimited version of Database Designer.
Data comparison improvements
While comparing data, dbForge Studio for MySQL 3.50 better caters for the diversity
of data comparison tasks. Custom object mapping delivers more freedom in comparison
- you can map tables, columns, and views with different names, map columns with
different types, or map a table with a view. Always you can cancel custom mapping
and return to the automatic one.
Mapping process is more simple and clear, now you get detailed information about
each mapped column and see warnings, for example, if a comparison key is set incorrectly.
You can quickly find the required object for mapping using the Find box or filtering
the list of objects by their status (the following are available: valid or invalid
mapping, auto or user mapped, fully or partially mapped, included or excluded in
comparison).
New mapping options Ignore Case, Ignore Spaces, Ignore Undercores are added to let
you customize the comparison. Data comparison of any amounts of data has been accelerated
and now is 5-10 times faster delivering more customized and understandable comparison
results.
Schema comparison improvements
Schema comparison results management has become easier and quicker due to convenient
filtering by object type, update operation, or status, quick search by object name,
ability to group by comparison difference type and update operation or cancel grouping
at all. You can grasp the comparison results even quicker thanks to their new representation.
The new version offers more speedy synchronization process, moreover adds more visibility
and control, as you can preview the synchronization script for any object in the
comparison results to ensure the correct synchronization result on the first try.
Optimized approach in working with large SQL scripts
The new version provides a special Execute Script Wizard to enable quick and convenient
execution of large SQL scripts without waiting for their opening in the editor.
It takes only to select the script and enjoy the executed result.
New additions to free Express edition
The free Express edition of dbForge Studio provides more functionality for free.
Now it features the limited versions of Query Builder, powerful and visual tool
for easy query creation and management, and Database Designer, an advanced tool
for visual MySQL database design.
Other improvements
A number of bug fixes and minor improvements have enhanced the product performance
targeting better users' satisfaction.
09-Dec-08 Release of dbForge Studio 3.10
Support of multiple database project deployment connections
Now you can set different connections for project configurations. These connections
allow you to deploy the same database project to various servers. You get more freedom
in handling the project. For example, you can test the project on one server and
deploy the final version to another one.
Incremental database project synchronization with the server
Now when you apply the project changes to the server, you can deploy only the required
ones and be sure that no data on the server will be lost as during the usual deployment.
This feature is a good contribution to database development.
Database object dependencies supported
In prior versions the Generate DDL, Schema Export, New Project Wizard, Schema Synchronization
wizards generated SQL scripts paying no attention to object dependencies. Now all
objects in SQL scripts are generated based on object dependency sorting principle.
For example, if View 1 refers to View 2, View 1 will come first or tables will follow
those tables which refer to them.
This ensures that the generated SQL scripts will be executed without errors and
you won't lose your time for additional code editing.
Optimized SQL editor performance
SQL editor performance has been greatly increased due to optimized parsing of SQL
scripts. You can open and edit large SQL scripts quicker. Moreover, to speed up
your work, automatic switching off SQL editing features in large SQL scripts is
implemented.
Filter toolbar in Error List window
Filter toolbar is added to Error List window to show the quantity of errors, warnings,
and messages. Also it filters the list of records, so that you can access the records
of the selected type in one click.
Sample database project added to the installation
Learning the structure and peculiarities of database projects has become easier.
A sample database project, based on MySQL database Sakila, is added to the installation.
Using the sample, even beginners will quickly get the idea and start working with
projects successfully.
01-Aug-08 Release of dbForge Studio 3.00
Editions
Starting from the version 3.00, MyDeveloper Studio becomes dbForge Studio for MySQL
and is divided into three editions: Express, Standard, and Professional.
-
Express provides basic functionality for working with schema objects, user
accounts, and SQL scripts. Express edition is free.
-
Standard includes all must-have tools for database developers, such as a
debugger, Query Builder, code templates, object search, various export and maintenance
wizards.
-
Professional features database project development functionality, schema
and data comparison tools, SQL formatting and syntax checking.
Database Projects Greatly Improved
Project building to an SQL script is available with support of different build options
and build configurations. Project build includes SQL syntax check, reference check,
scripts processing with applying database options, and generating the result script
or several scripts based on the selected order.
-
Building project to a single script
-
Building project to a collection of scripts
-
Reference check on build
-
Multiple build configurations
-
Adapting build results to specified server version
-
Schema comparison tool integration
-
Refactoring of project objects
-
Easy deleting object from project
-
All project objects in code completion list
Schema Comparison
Schema comparison tool allows you to quickly compare and synchronize either two
schemas or a schema and a project. Based on your needs, a target schema can be synchronized
with a source one completely or partially. Schema comparison provides the following
features:
-
Compare database with database
-
Compare database with project
-
Synchronization between different server versions
-
Comparison results filtering
-
Schema synchronization script generation
-
Per object viewing of DDL differences
-
Exclude objects from synchronization
-
Save and load comparison settings
Data Comparison
Data comparison tool allows complete or partial comparing of data between different
schemas. Data differences are conveniently displayed. Data comparison provides the
following features:
-
Comparison of large tables
-
Optional view comparison
-
Custom comparison keys support
-
Option for BLOB data comparison
-
Comparison results filtering
-
Schema synchronization script generation
-
Per record viewing of data differences
-
Exclude tables and records from synchronization
-
Save and load comparison settings
SQL Formatting
Highly customizable code formatting allows you to set up various options for different
statement kinds. SQL formatting features:
-
Automatic formatting on statement delimiter
-
Automatic formatting on paste
-
Formatting of current statement, whole document, or several documents
-
Many options can be set individually for different kinds of statements
-
Automatic placing new lines and spaces
-
Automatic case setting
Code Refactoring
Renaming of a database object in a script or project is supported. All statements,
referencing to this object are automatically updated. All changes can be previewed
and disabled. Updating of text strings and comments is also supported.
SQL Syntax Check
You can check your code and quickly locate errors without using MySQL server. Syntax
check of the entire database project is also available.
Brand New Query Builder
Query Builder was completely re-designed to meet user needs. SQL syntax support
was significantly enhanced. A number of new features were added. They include the
following:
-
Support for subqueries on any nesting level
-
Powerful expression editor, which allows building very complex conditions without
typing code
-
Reworked diagram with much better appearance
-
Most actions can be performed with keyboard shortcuts
Extended Data Export
A range of supported formats for export is increased. Now you can export data even
to another database server through ODBC. Following output formats are now available:
CVS, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text and XML. Using well-designed
Data Export wizard, you can set additional parameters for each output format.
Improved Stored Routine Debugger
-
Support for session and server variables in watches
-
Some server function call processing improved
Search and Replace Extended
Following search and replace functionality was added:
-
Search in data
-
Search in LOB Viewer/Editor
-
Search and replace in project files
-
Search and replace in files on disc
Context-sensitive Help
MyDeveloper Studio provides "on the fly" support during your work. You can press
F1 to quickly retrieve reference information about MySQL statements, keywords, data
types and built-in functions from SQL editor.
Import and Export Settings
Import and Export Settings Wizard allows you to export and import all your settings,
layout, toolbars, keyboard shortcuts. Wizard also allows you to reset settings to
their default values. You may export, import, and reset settings completely or partially.
Support of new table features and storage engines
-
Partitioning support
-
Merge engine support
-
Falcon engine support
Summary Window
Summary window is added for quick access to database object properties when browsing
schema with Database Explorer. It displays information about currently selected
database object or a collection of objects.
20-Sep-07 Release of MyDeveloper Studio 2.10
Enhanced Code Templates
-
Code Templates window now allows you to preview code templates.
-
Code templates are now not organized in folders in the completion list and can be
inserted with a typing template shortcut and pressing the TAB key.
Database Explorer Enhancements
-
Database Explorer now stores navigation history.
-
Different icons are available for different types of tables and folders.
-
Column type and size can be displayed in the Database Explorer.
Other New Features
-
The same file can be included several times in the deployment order for project
deployment.
-
Security definer setting supported for views, stored procedures, and functions.
-
Comments for table columns are supported.
-
SQL Log output can now be customized.
-
Date format can now be set for the Data Editor.
-
Table columns can now be created using copy/paste operations.
06-Apr-07 Release of MyDeveloper Studio 2.00
Stored routines and SQL debugging support
Added stored procedure and SQL script debuggers.
MySQL Database Project Support
Added a project management framework for bookmarking related scripts and organizing
database developments. Projects can be deployed in any order and saved to a file.
Security Manager
Completely redesigned Security Manager to control user accounts.
Improved SQL Editor
Greatly improved SQL Editor. The following features were added:
-
Enhanced Find and Replace window let you search and replace text in all opened documents
and view search results in the Find Results window
-
Advanced Code completion includes keywords and objects from the parsed script
-
Parameter information
-
Quick information about pointed object in the script
-
Navigation bar for navigating to script objects and subobjects
-
Bookmarks
-
Syntax customization
-
In-place visual select statements editing with Query Builder window
-
Incremental search
-
Code navigation for jumping to the definitions of database objects and variables
Improved Working with Data
The following features added for working with data:
-
Direct data printing from data editor
-
Sequential fetch feature - not all the data can now be fetched at once, the cursor
is left opened to fetch data later
-
Data output can now be redirected to the Output window and viewed as text
-
Card View mode gives a visual way to view data rows
Session Manager
Added Session Manager for controlling and analyzing user sessions.
Extended Database Object Search
Added search in object data and stored procedure source code. You can now also perform
search on columns, constraints, and indexes.
Service Manager
Added Service Manager to find and control MySQL services.
Document Outlining
Added the Document Outline window for viewing the structure of SQL documents. To
simplify code navigation, DML commands, DDL statements, BEGIN ... END blocks and
variables are represented as single structural units.
Code Templates
Added an extensive collection of SQL and stored routine code templates.
Hot keys customizing
Added fully customizable keyboard mapping schemes.
Other new features
Table maintenance, flush and server variables support Event object support Now you
can open several object editors for the same type of object in one document. The
Output window now has several tabs for viewing different kinds of messages.
21-Apr-06 Release of MyDeveloper Studio 1.51
Large database import improved
MySQL Developer now allows choosing a database to import data to. Import operation
performance increased.
03-Nov-05 Release of MyDeveloper Studio 1.50
User and Privileges Management
There are also many MySQL Developer improvements. User Manager and Grant Manager
allow you to easily manipulate MySQL accounts and privileges.
Database Export/Import
Database Export Wizard gives you a flexible export of a database or some database
objects to a script. Database export can be tuned with a lot of options. You can
export objects' structure, tables' data or both of them. Database Import wizard
can import a database from a script in a few clicks.
Trigger Support
MySQL Developer now supports triggers. You can use visual Trigger editor to create
or edit them.
Script Support
Now you can edit or execute not only single queries but scripts too.
Stop Execution Feature
All queries and scripts are now executed asynchronously. You can continue working
on other documents while executing a script. At any time you can interrupt its execution
pressing the Stop execution button.
Execution of Selected SQL Fragment
You can now select and execute any part of a script or query.
Data Export
Data Export wizard allows you to export data to an external format. Export to HTML,
XML, MS Excel, and Text format is supported. You can set different export options
to change the result file appearance.
Dynamic Data Viewing
Use Dynamic Data Viewing to view data of a table or view just by selecting it in
Database Explorer.
Paginal Data Access Mode
If a table has many records, you can use Paginal Mode to view data in parts. You
can set page row count to view as many records on the page as you wish.
LOB Viewer/Editor
LOB Viewer and Editor allows you to view and edit BLOB and Text data in corresponding
table fields.
Database Object Search
MySQL Developer allows you to search for database objects by name and type. You
can search for an object in specific databases or in the whole server.
Secure SSL and SSH Connections Support
You can now use SSL and SSH connection for secure working with data.
Query Plan Tool
With Query Plan Tool you can analyze select statements and improve a table structure.
Duplicate Object
This feature allows you to duplicate any database object into the same or another
database.
DDL Generation Wizard
This wizard generates DDL script for selected database objects. You can select objects
from one or several databases for DDL script generation.
Embedded Server Support
Connection to the embedded server can be now established.
Tabbed Groups for Documents
You can open several tab groups with documents, resize them, move documents from
one group to another, show only one document group.
Drag-n-Drop Files
You can now drop files on MySQL Developer window to open them. There are also many
MySQL Developer improvements.
12-Apr-05 Release of MyDeveloper Studio 1.00