MyDeveloper Studio - Application - V2.1 - 概要

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

結果

MyDeveloper Studio by Devart (formerly Core Lab)

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.

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.

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

PartNumbers: PC-517100-136313 517100-136313

PurchaseOptions: MyDeveloper Studio V2.1 1 User License

Resources: Read the MyDeveloper Studio help file, Download the MyDeveloper Studio V2.1 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

Keywords: crlab corelab SQL query language Development Database DB Management Author