Features

 

PHP-based Web Pages - New!	DBACentral for MySQL allows you to create php-based web pages for viewing and editing MySQL data through the web. You can create design web forms with tables, input controls, images, etc. using WSIWYG designer, edit HTML source directly, select preferable interface from several pre-defined templates, view the result page data directly within the application, and perform a lot of other actions, which will make your MySQL/PHP development much easier and faster.
SSH Tunneling - New!	DBACentral provides the in-application SSH tunneling client for establishing secure SSH connections to your MySQL databases.
Easy database management	With DBACentral you can create databases in several ways, manage database structures, import and export databases from/to various data sources and file formats, backup, restore, and drop databases, and perform other operations in easy-to-use graphical user interface.
Managing tables, columns, indexes, and keys	DBACentral for MySQL allows you to create tables in several ways, design table by creating, editing, repositioning, or dropping, columns and indexes, work with column domains, table relationships, and many more.
Easy migration from Microsoft Access to MySQL	If you are new to MySQL you will not experience any difficulties working with DBACentral for MySQL as its interface is intuitively understandable even for a novice. If you are used to work with MS Access databases, it will be even easier for you to migrate to MySQL - you can transfer all your databases just in few mouse clicks, and you will surely feel comfortable with DBACentral for MySQL interface and functionality.
Database Profiles	Database profiles allows you to work with MySQL databases using all the variety of DBACentral for MySQL functionality. Database profiles contain the connection properties, queries, forms, relationships, domains, and other information, which makes your work with MySQL easy and fast. Database profiles are stored in files on your hard disk and can be easily transferred between computers and databases.
Data Forms	DBACentral for MySQL provides the most powerful instrument for viewing and modification MySQL table data - user designed forms. Using data forms you can turn your DBACentral profile into a sub-application for working with the MySQL database.
Stored Queries	You can create queries for data viewing and modification in several different modes and save them in your profile for future use. The DBACentral query designer allows you to create powerful queries for the SELECT, INSERT, UPDATE, and DELETE statements using graphical interface.
Logical Data Integrity	DBACentral provides diagram-like interface for setting up logical or physical (if supported by server) references between table fields, which cascade data modification for the related fields and guard the referential data integrity. Relationships also lighten working with table data, building queries and forms a lot.
Creating stand-alone applications for end-users	You can use DBACentral for creating useful client-application for your database users. Just create forms for managing data, save them to the profile, and distribute among your database users along with the DBACentral Run-Time Edition.
Users and Privileges	In DBACentral for MySQL you can manage users and their privileges in a most easy way: create and delete users, define global and object-specific privileges for the selected user, or define access rights for a definite database table quickly.
Table Grid Environment	Working with data has never been as easy as in DBACentral for MySQL. It provides you with most handy interface for viewing/modifying table and query data as well as navigating between different data grids.
Useful wizards for constructing databases, tables, forms, queries	Databases, database objects and profile objects can be created in several ways within DBACentral for MySQL. The appropriate wizards provide the best way for quick creation of simple objects, guiding you thoroughly by the design process steps.
Powerful import modules	The following import modes are available in DBACentral for MySQL: Importing structure and data of existing MySQL databases; Importing structure and data of MS Access databases; Importing structure and data of various databases accessible through OLEDB or ODBC link; Importing table structure and data from MS Access, MS Excel, MS Word, HTML, XML, DBF, TXT, and other files.
Powerful export modules	DBACentral for MySQL provides variety of abilities for exporting databases and tables: Exporting database structure and data to MS Access file; Exporting database structure and data to MS Excel workbook; Exporting database structure and data to SQL script (dump database); Exporting database structure and data to multiple files of the selected format: MS Access, MS Excel, MS Word, HTML, XML, SQL, PDF, DBF, TXT, etc; Exporting table and query data to a single file of the selected format: MS Access, MS Excel, MS Word, HTML, XML, SQL, PDF, DBF, TXT, etc in two available modes: quick and comprehensive.
Support of stored routines - procedures and functions	DBACentral for MySQL provides full MySQL 5.0 support with ability to work with MySQL stored procedures and functions.
Support of data views	Database views, appeared in MySQL v5.0.1, are fully supported by DBACentral.
Full InnoDB compliance	DBACentral for MySQL supports all MySQL table types, including InnoDB, as well as InnoDB foreign keys.
Support of all field types	DBACentral for MySQL supports all MySQL field types, including BLOB and TEXT fields, and provides specific features for working with each of them.
Copying/pasting database objects	You can copy and paste tables, queries, forms and other objects within one database profile or different profiles and databases.
Native MySQL services	Using analyze/repair tables and other services is easy and fast to perform in DBACentral for MySQL.
Executing and monitoring SQL statements	DBACentral for MySQL provides tools for fast creation and execution of numerous SQL statements for data modification or viewing, and provides a dockable window for monitoring all statements executed within the application.
And a whole lot more...

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.