Integration with the most popular IDEs
MyDeveloper Tools brings MySQL development and administration power
to the newest development environments from Microsoft and CodeGear.
- Visual Studio 2008
- Visual Studio 2005
- Visual Studio .NET 2003
- Delphi 2007
- Delphi 2006
- Delphi 2005
|
|
Integration with MyDirect .NET and MyDAC
MyDeveloper Tools provides some special features for MyDirect .NET Data Provider Professional Edition and Data Access Components for MySQL (MyDAC). Easily open the visual query builder, SQL editor, or any object editor from component designers. Drag and drop objects from the Database Explorer to form designers to create preconfigured data components.
Convenient Server Browsing
Navigating through databases has never been easier.
An integrated Database Explorer window
lets you effortlessly browse the entire server hierarchy. It stores browsing history,
allowing you to navigate easily to previously visited database objects.
With one-click access to data and property views,
you can reach, view, and modify all database objects in seconds.
MyDeveloper Tools allows you to search for database objects
in selected schemas by name. You can also search for database objects by their DDL
and locate data in tables and views.
Stored Routines and SQL Script Debug
With MyDeveloper Tools, you can debug stored routines and perform step-by-step execution
of SQL scripts. MyDeveloper Tools lets you set breakpoints to stop execution on any line of code.
It includes a Call Stack window for viewing the currently active stack of
stored routine calls and a Watches window for evaluating variables.
Database Project Support
MyDeveloper Tools comes with an extensive project management system
that you can use create database projects and integrate related
database development files. Database project units make it
easer to manage large development projects
and automate routine database maintenance tasks.
You can use the Project Explorer to bookmark and integrate
separate scripts, query files and favorite database objects into projects,
work on them from a single workspace, and
easily deploy entire project batches, specifying the order of execution.
Built-in Object View window lets you easily navigate project files
and locate database objects created by the project scripts.
Advanced Database Administration Tools
MyDeveloper Tools features a powerful database administration toolkit, including
a Security Manager, a Session Manager, and other tools.
Security Manager allows you to perform the full range of database security
administration tasks such as manipulating
users, granting and revoking system and object privileges.
Session Manager lets you control user sessions
and watch their information.
Server Variables tool allows you to view and edit global server variables. Service Control window lets you look for, start, and stop MySQL services. Table Maintenance Wizard serves for performing table checking, analyzing, optimizing and reparing.
Advanced SQL Handling
Enhanced SQL editor provides many useful features to make the development process easier.
It simplifies SQL scripting by highlighting syntax as you type and helps
you write queries with context-sensitive code completion and parameter
information features for both scripts and
single statements. Moreover, a separate SQL
history keeps track of which SQL statements you have run and stores them so you
can recall any of them once you need it.
MyDeveloper Studio contains a number of most
frequently used code examples to use in your
SQL scripts or stored routines.
Document Outline window shows opened SQL document logical structure.
It can be used to view document elements and navigate to them.
Navigation bar eases navigation between DDL statements. Any SELECT statement in
a script or a stored routine can be visually designed with Query Builder.
Advanced Visual Query Builder makes it possible to
build even the most complicated queries without typing a single line
of text.
Simple Object Creation and Modification
With MyDeveloper Tools you will no longer need to spend hours
manually modifying database structure. MyDeveloper Tools
automates routine tasks and makes common database operations
easily accessible. You can create and duplicate
database objects directly from the Database Explorer and visually modify objects with
a set of powerful object editors. Object editors are optimized for
efficient database interaction and feature
intuitive and user-friendly layouts.
Moreover, MyDeveloper Tools gives you full control of the
database engineering process and lets you view the
DDL statements of each schema object and generate and
edit DDL scripts for multiple database objects.
Powerful Data Editing
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. A separate LOB Viewer and LOB Editor allow you to view and edit field values that contain binary and long text data.
Easy Data Exporting
You can export all the selected data or only specific rows and columns. Data export wizard helps you export data to Text, HTML, XML, and MS Excel file formats. Before exporting you can customize export style attributes, such as text, background and border color, font, and set output format of exported columns.
Flexible Database Export and Import
Database Export Wizard allows you to extract database to script. You can extract any database objects metadata, extract data from all or selected tables, set different extracting options, which affect the result script. Database Import Wizard provides you a very easy database restoring from a script.
- Direct Access to MySQL Server
MyDeveloper Tools does not require MySQL client library. Instead, it
talks to MySQL server directly via TCP/IP.
Wide MySQL Support
We support all range of MySQL servers from 3.2.3 to the latest hot version
from MySQL AB. In MyDeveloper Tools you can use most of features present in
MySQL. We also support every database object that exists in MySQL server 5.0.
