EMS SQL Management Studio for PostgreSQL

EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development.

With components that focus on all critical database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering databases and managing database objects as well as for database migration, extraction, data import, export and comparison.

SQL Studio unites these utilities in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential tools to make you more productive than ever before!

SQL Management Studio for PostgreSQL components:

SQL Manager for PostgreSQL - Simplify and automate your database development process, design, explore and maintain existing databases, build compound SQL query statements, manage database user rights and manipulate data in different ways.

Data Export for PostgreSQL - Export your data to any of 15 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML and more.

Data Import for PostgreSQL - Import your data from MS Access, MS Excel and other popular formats to database tables via user-friendly wizard interface.

Data Pump for PostgreSQL - Migrate from most popular databases (MySQL, PostgreSQL, Oracle, DB2, InterBase/Firebird, et .) to PostgreSQL

Data Generator for PostgreSQL - Generate test data for database testing purposes in a simple and direct way. Wide range of data generation parameters.

DB Comparer for PostgreSQL - EMS DB Comparer for PostgreSQL is an excellent tool for comparing PostgreSQL databases and discovering differences in their structure.

DB Extract for PostgreSQL - Create database backups in the form of SQL scripts, save your database structure and table data as a whole or partially.

SQL Query for PostgreSQL - Analyze and retrieve your data, build your queries visually, work with query plans, build charts based on retrieved data quickly and more.

Data Comparer for PostgreSQL - Compare and synchronize the contents of your databases. Automate your data migrations from development to production database.

Here are some key features of "EMS SQL Management Studio for PostgreSQL":
Basic features

Support of PostgreSQL versions from 7.1 to 8.1

Simple management of database objects (including create/edit/ drop operations)

Easytowork 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 (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

New state-of-the-art graphical user interface

Office 11 and Windows XP visual schemes support

Customizable toolbars for all program windows

Fully customizable program interface

Localizable program interface

Keyboard templates


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

64 MB RAM or more; 128 MB or more recommended

140MB of available HD space for program installation

Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended

Microsoft Mouse or compatible pointing device

Possibility to connect to any local or remote PostgreSQL server


Limitations:

30 day trial