Core Lab Announces Beta Version of MyDeveloper Studio
October 30, 2009
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 developmentproductivity. Starting with version 3.0, MyDeveloper Studio will be dividedinto three editions: Express (free of charge), Standard, and Professional.
Express Editionprovides basic functionality for working with schema objects, user accounts,and SQL scripts. Express Edition is free.
Standard Editionincludes tools for database development, like Debugger, Query Builder, codetemplates, object search, various export and maintenance wizards, etc.
ProfessionalEdition combines standard functionality with extended features required forprofessional database developers. Professional Edition includes databaseproject development, schema and data comparison tools, SQL code formatting, andsyntax check.
Project building to a SQL script is available with support of different buildoptions and build configurations. Project build includes SQL syntax check,reference check, scripts processing with applying database options, andgenerating the result script or several scripts based on the selected order. Itresults in a validated and ready to deploy script or a collection of scripts.
Projectconfigurations allow you to create several profiles with different options andbuild order for deploying your project into different MySQL servers. Projectrefactoring amplifies renaming of a project object with automatic update of allthe objects that reference it. All changes can be previewed and disabled.
The schemacomparison tool allows you to compare and synchronize either two schemas or aschema and a project. Based on your needs, a target schema can be synchronizedwith a source one completely or partially.
The datacomparison tool allows complete or partial comparing of data between differentschemas. Data differences are conveniently displayed. Comparing views also is allowed.
Customizable codeformatting allows you to set up various options for different statement kinds.SQL code can be automatically formatted while typing, and reformatted with theshortcut. The SQL Formatter wizard provides batch formatting.
You can check yourcode and quickly locate errors without using MySQL server. Syntax check of theentire database project is also available.
Query Builder hasbeen completely redesigned. SQL syntax support is significantly enhanced. An intuitiveUI provides visual creation of complex select statements without a single lineof code, convenient management of query properties, simple drag n dropaddition of tables, and quick navigating. The expression editor enables simpleand accurate creation of complex conditions.
The number ofsupported formats for export also has been increased. It includes CVS,DBF, HTML, Microsoft Access, Microsoft Excel, ODBC, PDF, RTF, Text, and XML. Youcan set additional parameters for each output format using the Data Exportwizard.
MyDeveloper Studioprovides on the fly support during your work. You can press F1 to quicklyretrieve reference information about MySQL statements, keywords, data types,and built-in functions from the SQL editor.
Also, the visualtable editor now allows you to create partitioned tables. Moreover, you can createMERGE and Falcon tables.
A new summarywindow allows for quick access to database object properties when browsingschema with Database Explorer. This window displays information about a currentlyselected database object or a collection of objects.
You can download MyDeveloper Studio version3.0 Beta from http://crlab.com/mysqldev/download.html.Visit the Core Lab Web site for more information: http://www.crlab.com/mysqldev. Anevaluation copy is available upon request.
Core Lab
Web Site: http://www.crlab.com
About the Author
You May Also Like