MySQL Developer Tools 2.00 offers you the following features:
Integration with MyDAC
Added MyDAC component designer extensions, including syntax highlighting, code completion, visual query building, stored procedure debugging, and others.
Stored Procedure and Script Debuggers
Added a framework for debugging stored procedures and SQL scripts.
Improved SQL Editor
Greatly improved the SQL Editor. The following features were added:
- Enhanced Find and Replace window lets you search and replace text in all opened documents and view search results in a 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
- In-place visual select statements editing with Query Builder window
- Incremental search is now available
- Code navigation for jumping to the definitions of database objects
- Syntax customization
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.
Keyboard Shortcut Customization
A set of keyboard mapping schemes with full customization added.
New Security Manager
Added integrated Security Manager for manipulating user accounts, granting and revoking privileges.
Table maintenance, flush and server variables
Added table maintenance wizard, flush dialog and server variables window.
Extended Database Object Search
Added full text and object data search. Completely redesigned Find Object window.
Service Control
New service management window lets you start and stop MySQL services under Windows.
MySQL Event support
Added support for the MySQL event object type.
Session Manager
Added a Session Manager for controlling and analyzing user sessions
Improved Working with Data
The following features added for working with data:
- You can now print data from data editor directly
- Sequential fetch feature was added - not all the data can now be fetched at once, cursor can be 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
Added an extensive collection of SQL code templates.
Document Outlining
Added a Document Outline window for viewing the structure of SQL documents. To simplify code navigation, DML commands,
DDL statements, code blocks and variables are represented as single structural units.
Other new features
- 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
We're looking forward to your comments and suggestions.
Core Lab development team
http://www.crlab.com/mysqldevtools