EMS Data Export for PostgreSQL is a powerful application to export your data quickly from PostgreSQL databases to any of 15 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF and others.
Data Export for PostgreSQL includes a wizard, which allows you to set export options for each table visually (destination filename, exported fields, data formats, and many others) and a command line utility to export data from tables and queries in one-touch.
Here are some key features of "EMS Data Export 2007 for PostgreSQL":
· Conceptually new user-friendly wizard interface
· Exporting to 15 most popular formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Clipboard
· Exporting data from several objects from different databases on one host
· Exporting data from tables, views and queries
· Selecting fields to export and changing their order
· Adjustable parameters for each exported table and specific parameters for each output format
· Access to PostgreSQL Server through HTTP protocol
· Connecting via local port forwarding through the SSH tunnel
· Saving all export parameters set on current wizard session
· Command-line utility to export data using the configuration file
· Powerful visual options module
Requirements:
· 300-megahertz (MHz) Pentium II-compatible or faster processor; 600--megahertz (MHz) or faster processor recommended
· 64 MB RAM or more; 128 MB or more recommended
· 20MB 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 recommended
· Microsoft Mouse or compatible pointing device
· Possibility to connect to any local or remote PostgreSQL server
Limitations:
· 30 day trial
· Exporting only 20 rows
· nag screen
What's New in This Release: [ read full changelog ]
· Unicode support. Now you are able to export Unicode data (from SQL Server, MySQL and PostgreSQL databases).
· Export from new formats is available now: MS Excel 2007, MS Word 2007, Open Document Format (Open Document Text and Open Document Spreadsheet), Generic XML with XSD schema
· Now you can use parameters in data export queries. The parameters are prompted in interactive mode in the wizard. In the Console version query parameters can be set in the command line or prompted in interactive mode.
· Utility source code significantly optimized, work speed increased.
· Now you can select destination server (SQL Server, Oracle, MySQL, DB2, etc.) when exporting to SQL format. Result script will be generated in accordance with the specifications of the target server.
· Wizard window is now resizable.
· An error used to occur when exporting tables containing VARCHAR fields with the length of more than 255 symbols to MS Access. Fixed now.
· Other minor improvements and bugfixes.
