 |
|
 No support for this feature at the moment Supports this feature only partially or not without some tweaking Full support for this feature This feature is fully supported and currently not available in any other similar products |
|||||||
| Versions | FreeMascon (Free) |
Mascon ($49) |
Competitor #1 ($125) |
Competitor #2 ($135) |
FreeMyCon (Free) |
MyCon Standard ($79) |
MyCon Pro ($139) |
| MySQL Object Management and Compliance | |||||||
|---|---|---|---|---|---|---|---|
| MySQL 3.x, 4.x and 5.x compliant | |
|
|
|
|
|
|
| Creating/Dropping Databases | |
|
|
|
|
|
|
| Creating/Altering/Dropping Tables | |
|
|
|
|
|
|
| Creating/Altering/Dropping Indexes | |
|
|
|
|
|
|
| Creating/Altering/Dropping Procedures | |
|
|
|
|
|
|
| Creating/Altering/Dropping Functions | |
|
|
|
|
|
|
| All MySQL Fieldtypes (incl.Blob/Memo) | |
|
|
|
|
|
|
| Built-in support for new 4.1 Authentication | |
|
|
|
|
|
|
| Connectivity | |||||||
| Multiple MySQL Server connections | |
|
|
|
|
|
|
| Customizable Databases Configuration | |
|
|
|
|
|
|
| Embedded MySQL Support | |
|
|
|
|
|
|
| SSL Connection support | |
|
|
|
|
|
|
| SSH Connection support | |
|
|
|
|
|
|
| Transaction support/Transaction safe | |
|
|
|
|
|
|
| Shared connections for multiple open objects | |
|
|
|
|
|
|
| Multi-threaded connections/Multi-tasking | |
|
|
|
|
|
|
| Cached Updates | |
|
|
|
|
|
|
| Efficiency in dumping 1Gb table to a script | |
|
|
|
|
|
|
| Navigation & Interface | |||||||
| Centralized global navigation of all objects | |
|
|
|
|
|
|
| Incremental searching of all MySQL Objects | |
|
|
|
|
|
|
| Desktop saving on exit | |
|
|
|
|
|
|
| Shortcut support to any object or view | |
|
|
|
|
|
|
| Customizable Toolbars | |
|
|
|
|
|
|
| Favourite link support for any object or view | |
|
|
|
|
|
|
| Drag & Drop and Copy & Paste of folders | |
|
|
|
|
|
|
| Comparative views of different data objects | |
|
|
|
|
|
|
| Help System & Support | |||||||
| Context Sensitive | |
|
|
|
|
|
|
| What is? on any object or view | |
|
|
|
|
|
|
| Email Support | |
|
|
|
|
|
|
| Open online support forum | |
|
|
|
|
|
|
| Table Editing & Data Manipulation | |||||||
| Create/Alter/Drop of Tables & Indexes | |
|
|
|
|
|
|
| Tabular data (by row) view | |
|
|
|
|
|
|
| Card/Form (by column) data view | |
|
|
|
|
|
|
| Multiple customizable Field Editors | |
|
|
|
|
|
|
| Blob/Memo Editor (Text, JPG, GIF, ICO, PNG, BMP, EMF, WMF) | |
|
|
|
|
|
|
| Auto-fill of Blob/Memo with URL contents | |
|
|
|
|
|
|
| Data Grid customization & control | |
|
|
|
|
|
|
| Column/Row sequence altering | |
|
|
|
|
|
|
| Data filtering & Filter Wizards | |
|
|
|
|
|
|
| Per record column excel-style filtering | |
|
|
|
|
|
|
| Data limiting | |
|
|
|
|
|
|
| Show/Hide of columns | |
|
|
|
|
|
|
| Multi-level column Grouping | |
|
|
|
|
|
|
| Column maths, ex AVG,MIN,MAX | |
|
|
|
|
|
|
| Multi-column Sorting | |
|
|
|
|
|
|
| SQL Monitor/Logger | |
|
|
|
|
|
|
| Instant Table Report | |
|
|
|
|
|
|
| Instant Table Backup/Dump Metadata | |
|
|
|
|
|
|
| Instant Table Scheduled Backup/Dump | |
|
|
|
|
|
|
| Instant Report print formats, Clipboard, PDF, XLS, RTF, HTML, XML, Text | |
|
|
|
|
|
|
| Import Wizard formats: Text, Excel, Word, DBase, Paradox, WKS, Quattro, Clipboard, XML, HTML, Access, ADT, SPSS, Clarion, ADO, DBISAM Export Wizard formats: Clipboard, Text, Excel, Word, DBase, Paradox, WKS, Quattro, XML, HTML, Access, SQL, SPSS, SYLK, DIF, LDIF, PDF, RTF, ADO |
|
|
|
|
|
|
|
| Drag & Drop and Copy & Paste of tables to and from other databases and/or servers | |
|
|
|
|
|
|
| SQL Queries | |||||||
| Tabular data (by row) view | |
|
|
|
|
|
|
| Card/Form (by column) data view | |
|
|
|
|
|
|
| Multiple customizable Field Editors | |
|
|
|
|
|
|
| Data filtering & Filter Wizards | |
|
|
|
|
|
|
| Per record column excel-style filtering | |
|
|
|
|
|
|
| Show/Hide of columns | |
|
|
|
|
|
|
| SQL Monitor/Logger | |
|
|
|
|
|
|
| Instant Query Report | |
|
|
|
|
|
|
| Instant Query Backup/Dump metadata | |
|
|
|
|
|
|
| Instant Query Scheduled Backup/Dump | |
|
|
|
|
|
|
| Import Wizard formats: Text, Excel, Word, DBase, Paradox, WKS, Quattro, Clipboard, XML, HTML, Access, ADT, SPSS, Clarion, ADO, DBISAM Export Wizard formats: Clipboard, Text, Excel, Word, DBase, Paradox, WKS, Quattro, XML, HTML, Access, SQL, SPSS, SYLK, DIF, LDIF, PDF, RTF, ADO |
|
|
|
|
|
|
|
| Drag & Drop and Copy & Paste of queries to and from other databases and/or servers | |
|
|
|
|
|
|
| Full Query data editing | |
|
|
|
|
|
|
| Cascading editing on JOIN-type Queries | |
|
|
|
|
|
|
| SQL Scripts | |||||||
| Supports SQL Scripts | |
|
|
|
|
|
|
| Instant Script Run/ Backup/ Metadata | |
|
|
|
|
|
|
| Drag & Drop and Copy & Paste of scripts to and from other databases and/or servers | |
|
|
|
|
|
|
| Instant Script Scheduled Run/ Backup/ Metadata | |
|
|
|
|
|
|
| SQL Editing/Creation | |||||||
| SQL Editor | |
|
|
|
|
|
|
| Visual SQL Editor | |
|
|
|
|
|
|
| Auto-Proposals (Context sensitive) | |
|
|
|
|
|
|
| Auto-Parameters for MySQL functions | |
|
|
|
|
|
|
| Auto-Completion | |
|
|
|
|
|
|
| Auto-Correct | |
|
|
|
|
|
|
| Report Designer & Report Management | |||||||
| Create/Alter/Drop Report Templates | |
|
|
|
|
|
|
| Create/Alter/Drop Archived Reports | |
|
|
|
|
|
|
| Report Export Formats, RAF, PDF, XLS, HTML, XML, Text, Clipboard | |
|
|
|
|
|
|
| Report Scripting Support | |
|
|
|
|
|
|
| Instant Report Scheduling | |
|
|
|
|
|
|
| Tasks & Scheduling | |||||||
| Create/Alter/Drop Tasks | |
|
|
|
|
|
|
| Backup Tasks | |
|
|
|
|
|
|
| Dump/Data Transfer Tasks | |
|
|
|
|
|
|
| Query/Script Run Tasks | |
|
|
|
|
|
|
| Standalone MyRun Dump/Reporting utility | |
|
|
|
|
|
|
| Report Print & Export Tasks | |
|
|
|
|
|
|
| Security & Management | |||||||
| Create/Alter/Drop Security Objects | |
|
|
|
|
|
|
| Context Sensitive Security Objects | |
|
|
|
|
|
|
| Cascading updating of Security Objects | |
|
|
|
|
|
|
"It is that one missing feature you need extremely bad one day which makes you inefficient"
|
Home •
Forum •
Campus •
Help •
Secure •
Contact •
Network •
About |
|
Copyright © SciBit - Scientific Bitware |
|
     |
|
