dbForge Studio for MySQL History
01-Aug-08 New features in dbForge Studio for MySQL v 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. Following features were added:
- 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 New features in 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 New features in 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 Improvement in 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 New features in 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.