EMS SQL Manager 2005 for MySQL

State-of-the-art GUI tool for MySQL Server administration and development EMS SQL Manager for MySQL is a high performance tool for MySQL Database Server administration and development.

SQL Manager for MySQL works with any MySQL versions from 3.23 to 5.06 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on.

EMS SQL Manager 2007 for MySQL offers plenty of powerful tools in order for experienced users to satisfy all their needs.

SQL Manager for MySQL has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Here are some key features of "EMS SQL Manager 2005 for MySQL":
Full support of MySQL versions from 3.23 to 6.0

Support of all MySQL objects (Tables, Views, UDFs, Stored Procedures and Functions, Triggers and Events)

Support of all MySQL features and extensions

Support of UTF8 data

Rapid database management and navigation

Multiple host/database connections

Connection to MySQL Server through HTTP

Connection to MySQL Server through SSH

Registering selected databases to work with

Projects to work with the selected database objects only

Multiple user-defined tabs for any tree node to access it in one-click

Working with multiple selected objects at a time

Grouping/Ungrouping registered databases by host name

Simple management of all MySQL objects

Ability to create/drop databases

Managing tables and all their subobjects: fields, indices, foreign keys and triggers

Managing views, stored functions and procedures, user-defined functions (UDF), scheduled events

Duplicating all database objects

Advanced data manipulation tools

View, edit, search, group, sort, filter any data stored in registered database

Powerful BLOB viewer/editor with several types of viewing BLOB data

Master-detail view to work with two linked tables at the same time

Table and card views to see data the way you like

Support of queries returning Multiple Result sets

Ability to copy and paste selected records

Exporting data to SQL script as INSERT statement

Powerful security management

Powerful user manager to administer users and privileges

Grant manager displaying all database object grants in the form of a grid

Excellent visual and text tools for query building

Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax

Multiple SQL editors with code completion, syntax highlight and code folding

Large script execution (SQL script editor)

SQL Formatter (Available from SQL Editor context menu)

Favorite Queries (Save and use your frequently used queries easily)

Impressive data export and import capabilities

Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.

Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV

Copying metadata and data from one database to another as a whole or partially

Report designer with clear in use report construction wizard

Create Report Wizard allows you to create simple reports in a few clicks

Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree

Other useful tools to make your work with MySQL server as easy as it can be

Extracting metadata into text files or SQL script editor

Powerful print metadata module for creating customizable metadata reports

HTML report generator to create a detailed HTML report about your database quickly

SQL Monitor

Server Properties tool to view and change system variables, to view server status information

Powerful Visual Database Designer

Two diagram notations (IDEF1x and IE)

Useful diagram navigation tool

Reverse engineering

Several pages in one diagram to divide diagram into different subject areas

Ability to create/edit/drop database objects, visually set links between them

Virtual objects such as comments and virtual relationship

Saving as image or printing database diagram

A lot of visual customization options

Easy-to-use wizards performing MySQL services

Backing up database

Restoring database

Analyzing tables

Checking tables

Repairing tables

Optimizing tables

New state-of-the-art graphical user interface

Office 11 and Windows XP visual schemes support

Well-described Wizard System

Improved database explorer for easy management of all MySQL objects

Windows Toolbar to switch between windows easily, like in Windows Task Bar

Navigation bars with hot actions in most of the windows

Ability to save all program settings

Customizable toolbars for all program windows

Fully customizable program interface

Powerful visual options module

Localizable program interface

And other useful features

Keyboard templates

To-do list

External tool manager


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

64 MB of RAM or more; 128 MB or more recommended

50MB of available HD space for program installation

Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended

Microsoft Mouse or compatible pointing device

Possibility to connect to any local or remote MySQL server


Limitations:

30 days free trial