EMS SQL Manager for MySQL Freeware 4.3

Manager for MySQL Freeware 4.3 offers an useful asisstance  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.

Major Benefits:

1. FREE One Year of Maintenance already included!
2. FREE software updates and upgrades during Maintenance period!
3. FREE and unlimited Technical Support during Maintenance period!
4. Reasonable pricing for Maintenance renewal – from 20% per Year!
5. Volume discounts when buying two or more copies of one product
6. Cross-selling discounts on related products

Major Features:

1. Full support of MySQL versions from 3.23 to 6.0
2. Support of UTF8 data
3. Rapid database management and navigation
4. Simple management of all MySQL objects
5. Advanced data manipulation tools
6. Powerful security management
7. Excellent visual and text tools for query building
8. Impressive data export and import capabilities
9. Report designer with clear in use report construction wizard
10. Powerful Visual Database Designer
11. Easy-to-use wizards performing MySQL services
12. Connection to MySQL Server through HTTP
13. Connection to MySQL Server through SSH

Enhancements:

1. DB Explorer: Added the Search Panel for quick search within the tree. Window list is now available in the DB Explorer area, the corresponding tab has been added.
2. Added UTF8 support for metadata.
   
   • Procedures, functions and triggers containing national characters are now compiled correctly irrespective of the operating system settings.
   • National characters are also displayed correctly in the ENUM fields now.
3. Now it is possible to restore lost database connection automatically: the corresponding 'Automatically reconnect when connection is lost' option is added to the Options section of the Database Registration Info dialog.
   
4. Added the Find Option tool to the SQL Manager settings form, as well as to the Database Registration Info and Host Registration Info forms. The tool allows you to find the required option in the scope of all program settings by a word or an expression from the option title.
   
5. Table Editor. The support for tables of the FEDERATED type is implemented.
   
6. Extract Database Wizard.
   
   • The speed of working with large databases is increased.
   • It is now possible to add the delimiter directives upon extraction of procedures and triggers: the corresponding 'Add DELIMITER statements for stored routines and triggers' option is available in the wizard.
   • Adding comments is now optional: the 'Insert comments' option is added to the wizard.
7. Import Data Wizard.
   
   • Table fields can now be mapped to text columns automatically.
   • Now it is possible to specify encoding for imported TXT and CSV files.
   • While importing from a DBF file, selecting the ANSI or OEM parameter did not affect the result. Fixed now.
8. Visual Database Designer.
   
   • It is now possible to display the foreign key names in the diagram: the corresponding 'Draw FOREIGN KEY name' option is added.
   • Added the 'Materialize virtual relation' function that can be used to create a foreign key on the basis of a virtual relation.
   • he size of table fields is now displayed in the diagram.
   • When deleting foreign keys, you are now prompted for confirmation.
9. Restore Tables. Now you can manually input the names of tables that do not exist in the database to restore them.
   
10. Export Data Wizard.
    
    • When exporting the result of a query, it is possible to add the text of the query to the header and/or footer of the output file: the corresponding 'Add to Header’/’Add to Footer' buttons are added.
    • he 'Out of memory' error used to occur when exporting a large amount of records (more than 1000000). Fixed now.
11. Trigger Editor.
    
    • It is now possible to add and edit the DEFINER for triggers.
    • Code completion did not work after the table name and the dot (.) character. Fixed now.
12. The values of the unsigned bigint and unsigned int field types that exceeded 2147483647 are displayed and edited correctly now.
    
13. Grid View and Form View tabs.
    
    • Zero date (0000-00-00) is displayed and edited correctly now on the Form View tab.
    • Now it is possible to edit time within the entire range supported by MySQL: from '-838:59:59' to '838:59:59'. You should just select the 'hhh:nn:ss' format for displaying time (the Grid | Color & Formats section of the Environment Options dialog).
    • SQL Editor.
    • When the 'Group undo' option is enabled, rollback is performed more logically.
    • The Code Folding function for complex queries is improved.
    • The editor now works considerably faster; such features as syntax highlight, object hyperlinks are not disabled while processing large scripts.
14. Procedure Editor. An error occurred upon compilation of procedures with names longer than 60 characters. Fixed now.
    
15. Save Data Wizard. The templates did not work. Fixed now.
    
16. The Execute from file option did not work for UNICODE files. Fixed now.
    
17. Lots of other minor improvements and bugfixes.

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 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

WareSeeker Editor