| SQL Manager (full version) |
SQL Studio | |
|---|---|---|
| Basic features | ||
| Support of Oracle versions from 8.1.7 up to 12 | ||
| Simple management of all Oracle objects (including create/edit/ drop operations) | ||
| Easy-to-work integrated environment uniting all SQL Studio capabilities | ||
| DB registration and connection | ||
| Multiple home/database connections | ||
| Connection to Oracle Server through SSH | ||
| Registering selected databases to work with | ||
| Grouping/Ungrouping registered databases | ||
| Single repository for all DBs registered with EMS Software Development applications. | ||
| DB management | ||
| Back Up any registered database | ||
| Restore previously backed up database | ||
| Powerful job manager to administer jobs | ||
| 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 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 | ||
