Core Lab Announces Beta Version of MyDeveloper Studio
Core Lab released a Beta version of MyDeveloper Studio 3.0. This version introduces features designed to enhance database development productivity. Starting with 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 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.
Project building to a 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 changes can be previewed and disabled.
The schema comparison tool allows you to 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.
The data comparison tool allows complete or partial comparing of data between different schemas. Data differences are conveniently displayed. Comparing views also is allowed.
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. The SQL Formatter wizard provides batch formatting.
You can check your code and quickly locate errors without using MySQL server. Syntax check of the entire database project is also available.
Query Builder has been completely redesigned. SQL syntax support is significantly enhanced. An intuitive UI provides visual creation of complex select statements without a single line of code, convenient management of query properties, simple drag n drop addition of tables, and quick navigating. The expression editor enables simple and accurate creation of complex conditions.
The number of supported formats for export also has been increased. It includes CVS, DBF, HTML, Microsoft Access, Microsoft Excel, ODBC, PDF, RTF, Text, and XML. You can set additional parameters for each output format using the Data Export wizard.
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 the SQL editor.
Also, the visual table editor now allows you to create partitioned tables. Moreover, you can create MERGE and Falcon tables.
A new summary window allows for quick access to database object properties when browsing schema with Database Explorer. This window displays information about a currently selected database object or a collection of objects.
You can download MyDeveloper Studio version 3.0 Beta from http://crlab.com/mysqldev/download.html. Visit the Core Lab Web site for more information: http://www.crlab.com/mysqldev. An evaluation copy is available upon request.
Web Site: http://www.crlab.com