|
|
Contents
Index
<< Previous
Next >>
PDF
Features
|
|
High-Degree of Compatibility:
| · | Supports MySQL databases starting with version 3.23
|
| · | Direct database access without using the MySQL DLL to reduce installing and connecting problems
|
| · | If desired, use of the MySQL DLL to access the database and thus compatible with future versions
|
| · | If the ISP prohibits external access to the database a HTTP tunnel can be used to have access the database nevertheless
|
| · | Full Drag&Drop and Copy&Paste support
|
| · | Intensive internal usage of the Windows API to make sure to be compatible with future Windows versions
|
Ease of Use:
| · | Windows-conformant use of all elements
|
| · | Clearly structured menu prompts
|
| · | Efficient use either via keyboard or with mouse only
|
| · | Data structure depiction same as in Windows Explorer
|
| · | Interactive dialogs to edit the entire data structures
|
| · | Data depiction within a customizable data grid
|
| · | Very fast because of efficient engineering and usage of the multi statement support
|
Individual Configuration:
| · | Language settings (more than 30 languages available, unicode supported)
|
| · | Various options to configure the database connection
|
| · | Numerous program use settings
|
| · | Syntax highlighting with individual colors
|
Standard Database Editing:
| · | Create, change and delete databases, tables, views, procedures, functions, events, triggers, indices, fields and foreign keys
|
| · | Create, change and delete data inclusive. Memo / BLOB using a HEX editor
|
| · | Display graphics in BLOB data (BMP, GIF, JPEG, PNG and RTF)
|
| · | Full Unicode support for data and identifiers
|
| · | Table partitioning support
|
Data / Data Structure Import:
| · | ODBC (Open Database Connector)
|
Data / Data Structure Export:
Enhanced Database Manipulations:
| · | Detailed Search inside whole table(s) / database(s) with regular expressions
|
| · | Fast Search&Replace inside whole table(s) / database(s)
|
| · | Whole database / table transfer between two different servers
|
| · | Easy Synchronisation between two databases / tables
|
Database Administration:
| · | Overview and ending of single processes and the entire server
|
| · | Detailed server status overview
|
| · | Configuration of server variables
|
| · | Highly individualized user rights administration
|
| · | Security settings on host level
|
| · | Table maintenance support (check, analyze, optimize, repair and "flush tables")
|
| · | Showing server error log
|
Rapid development:
| · | All database objects can be created, changed and removed without writing any SQL statement
|
| · | Database queries can be developed with a visual query builder by Drag&Drop very fast
|
| · | Context sensitive help of the SQL in the SQL Editor
|
| · | Executing partial selected SQL statements in the SQL Editor
|
| · | Editing values in the result set of an executed query in the SQL Editor and Query Builder
|
| · | Management of user-defined SQL scripts
|
| · | The source of Stored Procedures, Stored Functions, Triggers and Events can be edit like in a text in the notepad - SQL-Front handle the updates with a single key pressing
|
Efficient Troubleshooting:
| · | Distinct filtering and data sorting functions
|
| · | Logging of SQL queries sent to the database
|
| · | Display of source code of databases, tables, views, routines, events, triggers, users, hosts and processes
|
| · | Stored Procedures, Stored Functions, Triggers and Events can be executed for debugging with a single mouse click. Test data can be set and the result will be shown right beside the source code editor
|
| · | Printout of data, data structure and source code syntax highlighting
|
| · | Management of user-defined SQL scripts
|
See also:
|
|
