AnySQL Maestro Professional 9.8

AnySQL Maestro Professional 9.8 is a powerful software program that helps you much to administer many types of database like SQL Server, Oracle, MySQL and MS Access which is accessible via ODBC driver or OLE DB provider. The application provides you with easy - to - use GUI, which allows you to perform common database operations easy and fast. AnySQL Maestro Professional has Handy SQL Editor with code folding and multi - threading and visual query builder for data export and import to/from the most popular formats.

Major Features:

1. Basic Database Tools
   • Database Explorer
   • Object Creation Wizards
   • Object Editors
   • Object Browser
   • SQL Editor
   • SQL Script Editor
   • SQL Dump
   • SQL Generator
2. Advanced Database Tools
   • Database Designer
   • SQL Formatter
   • Database Report
   • Visual Query Builder
   • Data Analysis
   • Diagram Viewer
3. Data Management Tools
   • Data Editing
   • Data Filtering
   • Data Grouping
   • Data Printing
   • Data Exporting
   • Data Importing
   • BLOB Editor
   • Lookup Editors
   • Master-Detail Views

Enhancements:

• Server management extensions:
• • Support for check constraints has been added (if supported by DBMS and driver). You can create new check constraints, edit existing ones as well as drop checks.
  • Indexes and foreign keys are now refreshed correctly from the database and schema levels even if the corresponding driver/provider does not support such a possibility.
  • The SQL Dump Wizard now tries to produce the script compatible with the current SQL dialect instead of generating standard SQL statements. Moreover, it is now possible to generate multi-row INSERTs as well as specify the output file encoding.
• Interface improvements:
• • Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table columns within the dropdown window.
  • A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.
  • The possibility to display row numbers in grids has been added. Of course you can adjust the corresponding column to yours liking.
  • Now you can fix grid columns to view them permanently when working with other grid data. To fix a column, choose the corresponding item from the grid's header popup menu.
  • And more than that...