dbForge Fusion for MySQL History
09-Dec-08 New features in dbForge Fusion for MySQL v 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 loose 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 New features in dbForge Fusion for MySQL v 3.00
Editions
Starting from the version 3.00, MyDeveloper Tools becomes dbForge Fusion for MySQL and is divided into two editions: Standard and Professional.
- Standard includes all must-have tools for database development and maintenance, 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 a project to a single script
- Building a project to a collection of scripts
- Reference check on build
- Multiple build configurations
- Adapting build results to a specified server version
- Schema comparison tool integration
- Refactoring of project objects
- Easy object deleting from a 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 a database with a database
- Compare a database with a 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: CSV, 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 Option Extended
The 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 Tools 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 a schema with Database Explorer. It displays information about a currently selected database object or a collection of objects.
20-Sep-07 New features in MyDeveloper Tools 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 Tools 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.
17-Apr-06 Improvement in MyDeveloper Tools 1.70
Full integration into Visual Studio
This version is fully integrated into Visual Studio using software packages that run as a part of environment.
Compatible with Microsoft Visual Studio 2005 and Microsoft Visual Studio .NET 2003.
Since version 1.70, Microsoft Visual Studio .NET 2002 is no longer supported.
Data Designer Extensibility support (Visual Studio 2005 only)
Drag'n'drop from Database Explorer to DataSet designer supported.
03-Nov-05 New features in MyDeveloper Tools 1.50
User and Privileges Management
There are many MySQL Developer improvements. User Manager and Grant Manager provides easy manipulating of 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.