DBACentral for MySQL 1.6.1 Review
DBACentral for MySQL is a unique solution for database administration, development and data management. DBACentral for MySQL provides you with easy-to-use graphical user interface for executing all database operations: database structure management, table data manipulation, server administration, PHP forms generation and many more.
Main DBACentral for MySQL features:
PHP/HTML forms generation
Band-oriented report engine
Easy database management
Managing tables, columns, indexes, and keys
Easy migration from Microsoft Access to MySQL
Database Profiles
GUI Data Forms
Stored Queries
Logical Data Integrity
Users and Privileges
Table Grid Environment
Useful wizards for constructing databases, tables, forms, queries
Powerful import modules
Powerful export modules
Full InnoDB compliance
Support of all field types
Copying/pasting database objects
Native MySQL services
Executing and monitoring SQL statements
Requirements: Windows 9x/NT/2000/XP; MySQL stable version
What's New: [+] Comprehensive report engine is implemented. Now you are able to construct powerful data reports from tables or queries with the support of data bands, scripts in four available syntaxes, dialog pages, images, etc. You can create reports in several simple ways: with an auto-report tool, useful wizard or a rich featured designer. Generated reports can be viewed within DBACentral, exported into BMP, JPEG, PDF, RTF, HTML, Excel and other popular formats, or printed.
[+] The long-awaited ability to show all columns of a lookup field list right in the data grid or in the form lookup combo-box is added.
[+] Now you can use DBACentral queries or custom SQL for building forms and PHP web pages. The Auto Form, Auto Page, and Auto Report tools are also available for profile queries.
[+] The size and position of each DBACentral window now is being remembered and restored on next open.
[+] The ability to edit data in the autoincrement fields is added. Check the 'Allow Edit Autoincrement Fields' option at the Tables/Queries page of the Options dialog.
[*] Table Designer: now field length automatically changes for new fields to match the selected data type.
[*] Data import from MS Access is slightly improved.
[*] Some improvements to the bookmark system are implemented.
[*] Several changes to the web page generation engine are made.
[-] Fixed errors occurred with latest versions of MySQL server.
[-] The ENUM values, consisting of several words, are processed correctly now.
[-] A bug with importing relationships from other profile is fixed.
[-] The bug relating to converting VARCHAR field to FULLTEXT is fixed.
[-] The error, occasionally occurred on switching between the data grid segments is fixed.
[-] Problems with launching PHP Page Designer on WindowsXP with some security hotfixes are eliminated.
[-] A nasty bug occured after applying a filter to the form is fixed
[-] The incorrect forcing of Save As dialog is fixed.
[-] An error occurred while exporting data to Excel is fixed.
