Features

  SQL Manager
(full version)
SQL Studio
Basic features
Support of PostgreSQL versions from 7.1 up to the 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