What we can doOur Products CatalogOur SolutionsOrderSupportCompany
EMS SQL Manager™ for MySQL
administration and development



Features
EMS SQL Manager™ for MySQL - administration and development

Powerful graphical tool for database server administration and development. Its easy-to-use graphical interface and a lot of features will make your work as easy as it can be!

pricing starts from $95,00

Overview | Features | Screenshots | Reviews | Requirements | Ordering and Licensing | Downloads | Ask a Question | Report a Problem

Features Overview

Full support of MySQL versions from 3.23 to 5.06

  • Views support in MySQL 5.01
  • Stored Procedures and Functions support in MySQL 5.0
  • New MySQL 5.0 Authentication Protocol
  • MySQL 4.x User Privileges Extensions
  • Charsets and collations support for databases and tables

New state-of-the-art graphical user interface

  • Office 11 and Windows XP visual schemes support
  • New well-described Wizard System
  • Improved database explorer for easy managing of all MySQL objects
  • New 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

Rapid database management and navigation

  • Multiple host/database connections
  • Access to MySQL Server through HTTP protocol
  • Registering databases for working with the required databases only
  • Projects to work with the selected database objects only
  • Connecting via local port forwarding through the SSH tunnel
  • 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 and foreign keys
  • Managing views
  • Managing stored functions and procedures
  • Managing user-defined functions (UDF)
  • Duplicating all database objects

Advanced data manipulation tools

  • Powerful BLOB viewer/editor with several types of viewing BLOB data
  • Plenty of useful tools such as data grouping, fast searching and filtering
  • Master-detail view to work with two linked tables at the same time
  • Table and card views to see data the way you like
  • Ability to copy and paste selected records
  • Ability to create diagrams based on queries
  • Exporting data to SQL script as INSERT statement

Powerful security management

  • Powerful user manager for administering 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 and syntax highlight
  • Large script executing (SQL script editor)
  • SQL Formatter (Available from SQL Editor context menu)

Report designer with clear in use report construction wizard

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

Impressive data export and import capabilities

  • Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.
  • Exporting data to MS Access
  • Importing data from MS Excel, DBF, XML, TXT and CSV
  • Importing data from MS Access
  • Copying metadata and data from one database to another as a whole or partially

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

Completely remade 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 tables and table fields, visually set links between them
  • 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

And other useful features

  • Keyboard templates
  • To-do list
  • External tool manager


SQL Diagrams.
This application gives you a graphical overview of your SQL Server database solution, it visualizes all relationships between all database objects. .

Read more

DB tools recommendations.
Where is a requirement, there also is a tool that meets that requirement. Let us find you a perfect tool!

Read more

Database Solutions.
If you have a problem or you are in a need of a cost-effective IT solution for your business, we are here to help.

Read more