EMS SQL Manager for MySQL – это мощнейший инструмент для разработки и администрирования серверов баз данных MySQL. SQL Manager for MySQL гарантированно работает с любыми версиями MySQL, начиная с версии 3.23 и заканчивая версией 5.2 включительно. SQL Manager for MySQL поддерживает все самые новые функции MySQL, включая представления, хранимые процедуры и функции, внешние ключи для таблиц InnoDB и так далее. Целый набор мощных инструментов и утилит SQL Manager for MySQL удовлетворит все потребности опытных пользователей. Современный, максимально комфортный графический интерфейс и грамотная система мастеров настроек предельно просты и будут понятны даже начинающему пользователю.
Ключевые особенности* Полная совместимость со всеми версиями MySQL, начиная с 3.23 по 5.2 включительно
* Поддержка данных UTF8
* Быстрая навигация и управление базами данных
* Элементарное управление всеми объектами MySQL
* Эффективные инструменты управления данными
* Эффективное управление параметрами безопасности
* Великолепные графические и текстовые инструменты для построения запросов
* Впечатляющие возможности импорта и экспорта данных
* Конструктор отчетов с понятным мастером создания отчетов
* Мощный визуальный конструктор баз данных
* Удобные мастера для выполнения сервисов MySQL
* Доступ к серверу MySQL по HTTP протоколу HTTP туннелю
* Доступ к серверу MySQL по HTTP протоколу SSH туннелю
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.2 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It offers plenty of powerful tools 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.
Full support of MySQL versions from 3.23 to 6.0Support 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 navigationMultiple 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 objectsAbility 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 toolsView, 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 managementPowerful 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 buildingVisual 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 capabilitiesExporting 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 wizardCreate 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 beExtracting 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 DesignerTwo 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 servicesBacking up database
Restoring database
Analyzing tables
Checking tables
Repairing tables
Optimizing tables
New state-of-the-art graphical user interfaceOffice 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 featuresKeyboard templates
To-do list
External tool manager
Available Interface LanguagesRussianEnglish
German
Polish
Homepage - http://www.sqlmanager.net/en/products/mysql/manager