EMS SQL Manager 2007 Lite for MySQL

EMS MySQL Manager Lite is an excellent freeware graphical tool for MySQL Server administration. MySQL Manager works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It has minimal required set of instruments for those users who are new to MySQL server and need only its basic functionality. MySQL Manager 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.EMS MySQL Manager Lite is a graphical tool for MySQL Server administration.

Key features of "EMS SQL Manager 2007 Lite for MySQL":

· Full support of SQL Server 2005 permission system

· Assemblies, DDL Triggers, Aggregates and Synonyms support

· XML indexes, included index columns, index creation and lock options

· Maximum size for varchar, nvarchar, varbinary fields

· Typed XML columns

· Rapid database management and navigation

· Multiple host/database connections

· Connection to MySQL Server through HTTP

· 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

· Support of queries returning Multiple Result sets

· 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

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

· Large script execution (SQL script editor)

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

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

· SQL Monitor

· 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

Download