SQL Manager 2007 for PostgreSQL released!
Posted on 2007-05-17
EMS Database Management Solutions are pleased to announce SQL Manager 2007 for PostgreSQL - the new major version of the powerful PostgreSQL administration and development tool!
You can download SQL Manager 2007 for PostgreSQL at: http://www.sqlmanager.net/products/postgresql/manager/download
You can purchase SQL Manager 2007 for PostgreSQL at: http://www.sqlmanager.net/products/postgresql/manager/buy
What's new in SQL Manager 2007 for PostgreSQL?
- Support of UTF8 data in SQL Editor, Query Builder, Grid View, Data Export/Import Wizard.
- Now you can continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder or while table or view data are being loaded in the editor. A query taking too long to execute can be aborted when using PostgreSQL 8.0 and higher.
- New Database Statistics form added; it allows viewing various statistic information on database objects, helps to find weak points in database performance, indicates if it’s necessary to create new indices, etc. The corresponding options must be enabled in server configuration file (postgresql.conf.) for collecting statistics.
- All Wizards, including Data Export/Import, DB Extract, Copy DB wizards can now be run in the background mode, so that you could continue working with the program.
- New improved SQL Editor of the Visual Studio 2005 kind with Code Folding function and UNICODE support.
- Improved Data Import Wizard now allows to import data up to 10 times faster. New import formats have been added: HTML, XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007).
- Support of new PostgreSQL 8.2 features is implemented:
- FILLFACTOR parameter for tables and indices
- CONNECT permission for databases
- USAGE permission for sequences
- support of CREATE INDEX CONCURRENTLY
- ALTER TABLE [ NO ] INHERIT support
- creating domains based on other domains
- support of IF EXISTS clause in DROP operators of the Extract Database Wizard
- reassigning ownership of all objects owned by a role
- Object editors now contain the Permissions tab which allows to grant permissions on the object for users and groups.
- Common SQL commands can now be generated from DB Explorer (Script to SQL Editor, Script to Clipboard). Now you can easily generate such SQL commands as CREATE, ALTER, DROP, SELECT etc for each database object.
- Now you can save your queries in the Favorite Queries folders in DB Explorer; these queries сan be stored either locally in the registry (nobody but you will have access to them) or in a special database table (then all or some of your db users will have access to it).
- Download File wizard has been added, which allows to download and upload files from/to PostgreSQL server machine using standard PostgreSQL functions and FTP/SFTP protocols.
- Improved Visual database designer; new object type - comments - is added. One can now choose whether only object names or fields should be displayed. Now it is possible to select schemas whose tables should be added to the diagram when performing Reverse Engineering.
- Improved Data Export Wizard now works faster. New export formats have been added: XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007).
- Database Properties window has been added, which displays database options and allows to change some of them.
- Improved Table Editor. Now it is possible to view and change table properties on a new tab.
- Tasks menu is added in DB Explorer context menu. It contains common operations which can be performed on the object selected. Also hosts are now named in accordance with the selected connection type (SSH or HTTP tunneling).
- Improved report building system.
- Function Debugger. The variable that changed its value at the last step is displayed bold at the Debug Information window. The SQLSTATE and SQLERRM variables are also displayed now.
- Lots of other improvements and bug-fixes.
We hope you will enjoy working with our software.
This post has been migrated from a previous version of the PostgreSQL
website. We apologise for any formatting issues caused by the migration.