| SQL Manager (full version) |
SQL Studio | |||
|---|---|---|---|---|
| Basic features | ||||
| Support of latest MySQL and MariaDB versions |
|
|
||
| Support of all MySQL features and extensions |
|
|
||
| Simple management of all MySQL objects (including create/edit/ drop operations) |
|
|
||
| Easy-to-work integrated environment uniting all SQL Studio capabilities |
|
|
||
| DB registration and connection | ||||
| Multiple host/database connections |
|
|
||
| Connection to MySQL Server through HTTP/SSH |
|
|
||
| Registering selected databases to work with |
|
|
||
| Grouping/Ungrouping registered databases by host name |
|
|
||
| Single repository for all DBs registered with EMS Software Development applications. |
|
|
||
| DB management | ||||
| Back Up any registered database |
|
|
||
| Restore previously backed up database |
|
|
||
| Analyze tables |
|
|
||
| Check tables |
|
|
||
| Repair tables |
|
|
||
| Optimize tables |
|
|
||
| Powerful user manager to administer users and privileges |
|
|
||
| Grant manager displaying all database object grants in the form of a grid |
|
|
||
| Data manipulation | ||||
| View, edit, search, group, sort, filter any data stored in registered database |
|
|
||
| Export data in many formats (MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.) |
|
|
||
| Export data stored in different DBs in a single operation |
|
|
||
| Import data from many sources (MS Excel, DBF, TXT, CSV, XML, MS Access) |
|
|
||
| Import data from different sources to different DBs in a single operation |
|
|
||
| Convert database structure and data from OLE DB/ODBC data sources |
|
|
||
| Generate test data to several database tables at the same time |
|
|
||
| Console versions for all data manipulation utilities |
|
|
||
| Data Analysis | ||||
| DB comparison and synchronization ability |
|
|
||
| Data comparison and synchronization ability |
|
|
||
| Console versions for all data analysis utilities |
|
|
||
| Template management | ||||
| Create new templates for SQL Studio utilities |
|
|
||
| Edit existing templates for SQL Studio utilities |
|
|
||
| User friendly template manager. Fast access to the needed template. |
|
|
||
| Launch the utility for the selected template in one click |
|
|
||
| Scheduler | ||||
| Scheduled execution of DB service tasks (BackUp, Restore, etc.) |
|
|
||
| Scheduled execution of data manipulation tasks (Import, Export, etc.) |
|
|
||
| Scheduled execution of any external applications |
|
|
||
| Creation and execution of complex tasks |
|
|
||
| Storage of logs for executed tasks |
|
|
||
| Flexible system of task execution results notifications (email, net send, Application Log) |
|
|
||
| Log management | ||||
| Storage of logs for applications run by Scheduler |
|
|
||
| Ability to search, view, delete, export existing logs |
|
|
||
| Report designer | ||||
| New Create Report Wizard allows you to create simple reports in a few clicks |
|
|
||
| Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree |
|
|
||
| Other tools | ||||
| Extracting metadata and data into text files or SQL script editor |
|
|
||
| Extracting metadata and data from different DBs in a single operation |
|
|
||
| Console version of Extract metadata tool |
|
|
||
| Powerful print metadata module for creating customizable metadata reports |
|
|
||
| HTML report generator to create a detailed HTML report about your database quickly |
|
|
||
| SQL Monitor |
|
|
||
| SQL Query |
|
|
||
| Saving favourite queries |
|
|
||
| Saving query history |
|
|
||
| Ability to create diagrams based on queries |
|
|
||
| Visual Database Designer | ||||
| Two diagram notations (IDEF1x and IE) |
|
|
||
| Reverse engineering |
|
|
||
| Ability to create/edit/drop tables and table fields, visually set links between them |
|
|
||
| Saving as image or printing database diagram |
|
|
||
| Powerful and easy-to-use graphical user interface | ||||
| Office and Windows native visual schemes support |
|
|
||
| Customizable toolbars for all program windows |
|
|
||
| Fully customizable program interface |
|
|
||
| Localizable program interface |
|
|
||
| Keyboard templates |
|
|
||