MyDeveloper Studio

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Automate and simplify database development. MyDeveloper Studio is designed to automate and simplify database development processes. It also provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways. Using MyDeveloper Studio, you can: Create, modify and delete database connections, display server specific database schema information in tree view create, modify and drop various database objects and more.

Our regular prices are shown below. Please logon to see your discounted prices.

MyDeveloper Studio V2.1

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase.  All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

MyDeveloper Studio 2.10 offers you the following features:

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 typing template shortcut and pressing <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

• 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 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

What’s new in V2.0x?

• Stored Procedure and Script Debuggers - Added a framework for debugging stored procedure 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
• 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
• 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
• Code Templates - 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

Using MyDeveloper Studio, you can:

• Create, modify and delete database connections
• Display server specific database schema information in tree view
• Create, modify and drop various database objects
• Create and execute SQL statements using enhanced SQL editor
• Visually design queries using Query Builder
• Open and save SQL documents, view and edit table data using a grid-based data editor

MyDeveloper offers you a lot of additional useful features, some of them are:

• Wide connectivity
• Security Management
• Easy data exporting with support for HTML, XML, MS Excel, Text file formats
• Database export/import
• Convenient and flexible user interface
• Comprehensive help system

Convenient server browsing

A special window called the DbExplorer exposes server objects hierarchy in an easy-to-handle way. You can reach, inspect and modify a database object in seconds. One-click property view for all database objects is included. MyDeveloper Studio also allows you to search database objects in selected databases of any type by name. You can quickly retrieve data from views and tables just by selecting them in DbExplorer.

Simplified database objects creating and altering

With MyDeveloper Studio you will not need to spend too much time on modifying database structures because all frequent operations are automated and easily accessible. Powerful visual editors for server objects are designed to let you manipulate database objects in user-friendly way. MyDeveloper Studio allows you to view all database objects as DDL statements, generate and edit DDL scripts for multiple database objects. You can also easily duplicate database objects.

Advanced SQL handling

The visual query builder allows you to build even the most complicated queries without typing a single line of text. You can switch between visual and text modes whenever you want. The enhanced SQL editor simplifies SQL statement editing by highlighting syntax as you type and it helps you write queries with context-sensitive intellisense. Moreover, special SQL history keeps track of which SQL statements you have run and stores them so you can recall any if needed. MyDeveloper Studio allows you to compose and execute scripts as well as single statements. It also has a convenient feature that allows selected a fragment of the text within script to be executed.

Data editing

The grid-based data editor has everything you might require when inspecting and editing data. You can filter, group, and sort data in-place, as well as customize the grid, cache updates on client, or control data manipulation with connection-level transactions. The LOB Viewer in conjunction with the LOB Editor allows you to view and edit field values containing binary and long text data.

Easy data exporting

You can export all the data or select which rows and columns to export. The data export wizard allows you to export data to the following file formats: HTML, XML, MS Excel, Text. You may set export style attributes, such as text, background and border color, font and set output format of exported columns.

Flexible database backup and restore

The database export wizard allows you to extract the database to a script. You can extract any database objects metadata, extract data from all or selected tables, set different extracting options, which affect the result script. The database restore wizard provides you very easy database restoring from the created script.

Wide MySQL support

MyDeveloper Studio supports all ranges of MySQL servers from 3.2.3 to the latest hot version from MySQL. In MyDeveloper Studio you can use most of features present in MySQL.