23-May-08 MyDeveloper Studio v.3.0 Beta Available!
Core Lab announces the beta version of MyDeveloper Studio. Version 3.0
introduces a number of essential features which boost database development productivity.
Starting from version 3.0 MyDeveloper Studio will be divided into three Editions:
Express (free of charge), Standard, and Professional.
- Express Edition provides basic functionality for working with schema objects,
user accounts, and SQL scripts. Express Edition is free!
- Standard Edition includes all must-have tools for database development, like Debugger,
Query Builder, code templates, object search, various export and maintenance wizards, etc.
- Professional Edition combines standard functionality with extended features required for
professional database developers. Professional Edition includes database project development,
schema and data comparison tools, SQL code formatting and syntax check.
Enhanced Database Project
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. It results in a validated and ready to deploy script or a collection
of scripts.
Project configurations allow you to create several profiles with different options and build order for
deploying your project into different MySQL servers.
Project refactoring amplifies renaming of a project object with
automatic update of all the objects that reference it. All the changes can be
previewed and disabled. Code completion list contains all project objects.
Schema comparison
Schema comparison tool allows you to compare and synchronize quickly 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.
Data comparison
Data comparison tool allows complete or partial comparing of data between different
schemas. Data differences are conveniently displayed. Comparing of views is also allowed.
SQL Formatting
Highly customizable code formatting allows you to set up various options for different
statement kinds. SQL code can be automatically formatted while typing and reformatted
with the shortcut. SQL Formatter wizard provides batch formatting.
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 has been completely re-designed and renovated to meet your needs. SQL syntax
support is significantly enhanced. Intuitive UI provides visual creation of complex select
statements without a single code line, convenient management of query properties, simple
drag'n'drop addition of tables, and quick navigating. Powerful expression editor enables
simple and accurate creation of complex conditions.
Extended Data Export
The number of supported formats for export is increased. It includes 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.
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.
Support of new table features and storage engines
Now visual table editor allows you to create partitioned tables.
Moreover you can create MERGE and Falcon tables.
Summary Window
Summary window is added for quick access to database object properties
when browsing schema with Database Explorer. Window displays information
about currently selected database object or a collection of objects.
You can download MyDeveloper Studio version 3.00 Beta from its
download page.
To tell us what you think about the new release, visit the
MyDeveloper Studio Feedback Page.
We are looking forward to your comments and suggestions.