Mensys Online Shop
| Categorie: | Productiviteit - Gereedschappen | Van: | MicroOLAP Technologies |
| Meer informatie: | microolap.com/dba/my... | ||
DBACentral for MySQL is a GUI solution for database administration and data management, which provides you with Microsoft Access like interface paradigm for executing all database operations over database structure and table data. What makes DBACentral for MySQL different from other products: Extending MySQL
|
Alle prijzen zijn in Euro excl. BTW (19%, voor boeken 6%) en excl. verzendkosten.
E-mail of bel 023 548 20 20 voor licenties, upgrades en andere vragen.
DBACentral for MySQL is a GUI solution for database administration and data management, which provides you with Microsoft Access like interface paradigm for executing all database operations over database structure and table data.
What makes DBACentral for MySQL different from other products:
Extending MySQL
- create custom GUI data forms for viewing and updating table data
- use table references with any MySQL server
- create stored queries
- use stored domains for quicker table design
- create PHP-based pages for working with MySQL data through the web
Fast Database Migration
- import from MS Access or any other ADO-compatible source
- reverse engineer MS Access database structure, including table relationships
- transfer data from MS Access, MS Excel, HTML, XML, etc.
- feel comfortable with the familiar Access-like interface paradigm
Full Database Administration
- create, drop, backup and restore databases
- create, modify, copy and drop tables, columns, and indexes
- setup database security policy: manage server users and their privileges
- analyze, check, and repair database tables
- set foreign keys and logical relationships in a diagram-like interface
- create, modify, and execute stored procedures and functions
- create and manage database views
Ease of Use
- manipulate objects using intuitive graphical interface
- perform database operations through helpful wizards or comprehensive designers
- establish multiple database connections and transfer data quickly
- create and execute SQL queries in several modes
- connect to MySQL through the secure SSH shell
Ultimate Data Management
- create inside end-user applications with custom data forms
- use powerful grids for data viewing and modification
- use subgrids to work with linked data
- guard data integrity with logical or physical relationships
- integrate your MySQL data with 14 available file formats
- deploy complete database solutions within your organization using the Run-Time Edition
What is DBACentral?
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, and many more.
DBACentral for MySQL also offers you a lot of powerful extensions for MySQL functionality, allowing you to work with MySQL tables in a completely new way. Designing tables, keeping data integrity, and working with table data become as easy as never before.
Using DBACentral for MySQL you can create database tables in several ways, design table structures and manage table data, set up the database security policy, create and drop databases, create storable queries for all types of SQL statements in visual environment, execute SQL queries and scripts and perform a lot of other operations easily.
5-2005A new level of data management
With DBACentral for MySQL you can not only manage databases, but also create comprehensive applications for data management by using DBACentral for MySQL unique features - forms and relationships. Say "good bye" to routine operations for data modifications - data forms will meet all your requirements.
Powerful export/import modules allow you to export and import MySQL databases and tables to/from 14 available formats, including import from any ADO-compatible databases or MySQL databases, MS Excel, MS Access, MS Word, HTML, XML, PDF, and many more.
DBACentral for MySQL allows you to provide full data integrity within your database irrespectively of your MySQL server version or database table types. You can create and modify logical references between table fields, which cascade data modification for the related fields and simplify the process of managing data within forms and grids. Of course, physical references (InnoDB foreign keys) are also supported.
Migration from Microsoft Access
With DBACentral for MySQL Microsoft Access users can easily migrate to native MySQL environment with minimum loss of standard Access functionality as the main principles of working with tables, queries, and forms are quite similar.
Full list of current changes:
- Sorting, grouping and filtering functions in the Table Data View window are improved. Now these functions are applied to the whole table data set, not to the single segment of data. Still, if you want to use the old-style mode of sorting and filtering, use the 'Filter/sort current segment only' option in the Options dialog.
- PHP generation is significantly improved. Now web pages work with PHP5 correctly.
- Fixed several bugs with export to SQL.
- Fixed bug with importing data from CSV.
- Problems with exporting database to an Excel workbook are fixed.
- The bug with displaying long VARCHAR fields is fixed.
- Fixed bug with parsing DOUBLE and FLOAT fields in the SQL View mode of the Table Designer.
- Fixed bug with opening tables, which contain dots in field names.
- The 'comment too long' error occurred on altering InnoDB tables is fixed.
- Fixed bug with resizing procedure and function designers.
- Fixed bug with opening User Designer on later MySQL versions.
- Fixed some bugs with the Report Designer.
- Several other minor improvements.