Make homepage|Add to favorites

reviews, articles, tips & snippets

Buy SQL » MySQL » Tools » EMS SQL Management Studio for MySQL

EMS SQL Management Studio for MySQL

Author: Dicentis Date: 31-03-2011, 10:50

EMS SQL Management Studio for MySQL is a powerful solution for MySQL database administration and development. Management Studio is a single workbench that includes must-have tools for database development, managing database objects, exporting and importing data, schema and data migration from popular databases, comparing and synchronizing databases, backuping and restoring tables, data editing and query building. Many of administration tasks can be automated with a Scheduling & Performing Tasks abilities. Useful database designer allows to create, edit or drop database objects and visually set links between them.



EMS SQL Management Studio for MySQL


SQL Management Studio 2011 for MySQL components:

  • SQL Manager for MySQL - Simplify and automate your MySQL database development process, design, explore and maintain existing MySQL databases, build compound MySQL query statements, manage MySQL database user rights and manipulate data in different ways.
  • Data Export for MySQL - Export MySQL database data to any of 19 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML and more.
  • Data Import for MySQL - Import data to MySQL database tables from MS Access, MS Excel, CSV, XML and other popular formats via user-friendly wizard interface.
  • Data Pump for MySQL - Migrate from most popular databases (MS SQL Server, PostgreSQL, Oracle, DB2, InterBase/Firebird, etŮ.) to MySQL. Convert database schema and import table data to MySQL database from any ADO-compatible source.
  • Data Generator for MySQL - Generate test data for MySQL database for testing purposes in a simple and direct way. Wide range of data generation parameters, user-friendly wizard interface and useful console utility to automate MySQL test data generation.
  • DB Comparer for MySQL - Compare and synchronize the structure of MySQL databases. Move changes on your development database to production with ease.
  • DB Extract for MySQL - Create MySQL database backups in the form of SQL scripts, script and save your MySQL database structure and table data as a whole or partially.
  • SQL Query for MySQL - Analyze and retrieve your data, build your MySQL queries visually, work with MySQL query plans, build charts based on retrieved data quickly and more.
  • Data Comparer for MySQL - Compare and synchronize the contents of your MySQL databases. Automate your data migrations from development to production database. Customize the MySQL comparison and synchronization process to suit your needs.

    EMS SQL Management Studio for MySQL


    User Interface:

    SQL Studio unites all database tools in one easy to use environment. Studio provides rich and clear in use interface with well-described wizard system. The localization options allow to change program interface language. The interface options allow to customize graphical style; some visual schemes including Windows XP and Office 11 are supported.


    Management Studio works with all MySQL versions from 3.23 to the newest one and supports all schema objects and database features.


    Microsoft® Windows NT4 with SP4 or later, Microsoft® Windows 2000, Microsoft® Windows 2000 Server, Microsoft® Windows XP, Microsoft® Windows 2003 Server, Microsoft® Windows Vista.


  • Multiple host/database connections
  • HTTP tunneling - establishing HTTP connections while direct connections to MySQL server is not allowed
  • SSH tunneling - secure database connections
  • Support of all MySQL objects
  • Ability to create, drop, modify, duplicate objects
  • Support of UTF8 data
  • Advanced data editor with BLOB viewer/editor
  • View, edit, search, group, sort and filter any stored data
  • Master-detail allows viewing linked data
  • Viewing multiple result sets
  • Export data to most popular formats, including MS Access, MS Excel, MS Word, PDF, HTML, ODF and more
  • Import data from MS Access, MS Excel, CSV, XML and other popular formats
  • SQL editors with code completion, syntax highlight and code folding
  • SQL code formatting
  • Saving favorite queries
  • Visual query builder
  • Powerful security management
  • Report designer
  • SQL Monitor
  • Visual Database Designer, Reverse engineering
  • Scheduled script execution
  • Notification system with various ways to send them out
  • Scheduling tasks

  • Tags: MySQL tools, EMS

    Dear visitor, you went to the site as unregistered user.
    We recommend you to Register or Sign In.


    Leave a comment
    Members of Guests cannot leave comments.