SQL Manager (full version) |
SQL Studio | |||
---|---|---|---|---|
Basic features | ||||
Support of PostgreSQL versions from 7.1 to latest one | ||||
Simple management of database 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 PostgreSQL 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 and server management | ||||
Analyze tables | ||||
Vacuum tables | ||||
Reindex databases, tables or indices | ||||
Powerful user and group manager to administer users/groups/roles | ||||
Grant manager displaying all database object grants in the form of a grid | ||||
Server Status service that shows current connections, transactions, locks and server log | ||||
Server Log Viewer to analyze server logs | ||||
Server Configuration service to tune server parameters and configuration files | ||||
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 (Analyze, Vacuum 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 |