| SQL Manager (full version) |
SQL Studio | |||
|---|---|---|---|---|
| Basic features | ||||
| Compatible with any InterBase server version up to XE7 | ||||
| Compatible with any Firebird server version up to 3.0 | ||||
| Simple management of all InterBase/Firebird 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 InterBase/Firebird Server through SSH | ||||
| Registering selected hosts to work with | ||||
| Registering selected databases to work with | ||||
| Grouping/Ungrouping registered databases by host name | ||||
| Single repository for all hosts and DBs registered with EMS Software Development applications. | ||||
| DB management | ||||
| Back Up any registered database | ||||
| Restore previously backed up database | ||||
| Database statistics | ||||
| Database validation | ||||
| Shutdown database/Bring database online | ||||
| 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 (e-mail, 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 | ||||