SQL Management Studio for PostgreSQL A complete solution for database administration and development
Download

SQL Management Studio for PostgreSQL Ranking & Summary

SQL Management Studio for PostgreSQL Tags

database manage database PostgreSQL Administration Database Administration database development

SQL Management Studio for PostgreSQL Description

SQL Management Studio for PostgreSQL is designed as a complete software collection for database management and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison. SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility. Whether you are a database or application developer, DBA or business analyst, SQL Studio for PostgreSQL offers all essential PostgreSQL tools to make you more productive than ever before. Main features: 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

SQL Management Studio for PostgreSQL Related Software