EMS SQL Management Studio for PostgreSQL

What is EMS SQL Management Studio for PostgreSQL?

EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components focused on all critical PostgreSQL database management tasks, SQL Studio is a single desktop that provides essential tools for managing PostgreSQL databases, managing schemas and database objects, as well as for design, migration, extraction, and querying of the PostgreSQL database, postgreSQL query construction,  import of data, export and comparison of databases. SQL Studio unites these database tools for PostgreSQL in a powerful, easy-to-use environment that can work 24 hours a day.

With SQL Management Studio, many database administration objectives, such as data migration, loading, and synchronization, can be automated, backed up, and database extraction, enabling PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks regularly with minimal effort and high level of flexibility. Whether you're a database or application developer, DBA, or business analyst, SQL Studio for PostgreSQL offers all the essential PostgreSQL tools to make you more productive than ever before!

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

Data Export to PostgreSQL - Export data from the PostgreSQL database to any of the 20 most popular data formats, including MS Access, MS Excel, MS Word, PDF, HTML, ODF, and more.

Data import to PostgreSQL - Import data to PostgreSQL database tables from MS Access, MS Excel, CSV, XML, and other popular formats through the wizard's user-friendly interface.

Data Pump for PostgreSQL - Migrate from the most popular databases (MS SQL Server, MySQL, Oracle, DB2, InterBase / Firebird, etc.) to PostgreSQL. Convert the schema from the database and import the table data into the PostgreSQL database from any ADO-compliant source.

Data Generator for PostgreSQL - Generate test data for the PostgreSQL database for testing purposes in a simple and straightforward manner. Wide range of data generation parameters, user-friendly wizard interface, and useful console utility to automate PostgreSQL test data generation.

Database comparator for PostgreSQL - Compare and synchronize the structure of PostgreSQL databases. Move changes in your development database to production with ease.

Database Extractor for PostgreSQL - Create PostgreSQL database backups in the form of SQL scripts, write and save your PostgreSQL database structure and table data as a whole or in part.

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

Data Comparator for PostgreSQL - Compare and synchronize the contents of your PostgreSQL databases. Automate your data migrations from development to production database. Customize the PostgreSQL comparison and synchronization process to meet your needs.

Additional SQL Studio features

• Practical release of utilities and services.
• Storing all models in a single repository.
• List of common data sources for all services and utilities.
• Creating complicated tasks and performing scheduled tasks.
• Ability to run external applications from the calendar.
• Storing all task execution logs in a database.
• Creating custom notifications with a variety of delivery options.
• Ability to define the visual interface style exclusively for all SQL Studio applications.
• Quick access to EMS Technical Support Service.

System resursos

• 300 MHz processor; Recommended 600 MHz (MHz) processor
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows Vista x64, Microsoft Windows 7, Microsoft Windows 7 x64
• 64 MB of RAM or more; 128 MB or more recommended
• 140 MB of available HD space for program installation
• Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended
• Microsoft mouse or compatible pointing device
• Microsoft Data Access Components (MDAC) or SQL Server Native Client
• Possibility to connect to any local or remote PostgreSQLServer