EMS Data Import for PostgreSQL is a powerful cross-platform (Windows and Linux) tool to import your data quickly from MS Excel, MS Access (Windows version only), DBF, TXT, CSV and XML files to PostgreSQL tables.
EMS Data Import 2007 for PostgreSQL is a software that import data from database to PostgreSQL tables.
EMS Data Import for PostgreSQL provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc.
PostgreSQL Data Import includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.
Here are some key features of "EMS Data Import 2007 for PostgreSQL":
· Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
· Importing data to one or several tables or views from different databases
· Special batch insert commands allow to import data at the maximum possible speed
· A number of import modes - Insert All, Insert New, Insert or Update, and others
· Secure Shell (SSH) and HTTP tunneling support
· UNICODE support
· Adjustable import parameters for each source file
· Saving all import parameters set on current wizard session
· Command-line utility to import data using the configuration file
· Powerful visual options module
· User-friendly wizard interface
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
· Windows compatible mouse or pointing device
· Possibility to connect to any local or remote PostgreSQL server
Limitations:
· 30 days trial
· Imports only 20 rows.
What's New in This Release: [ read full changelog ]
· The new Native method of import is added which includes two algorithms – Single Commands and Batch Insert.
· Import from new formats.
· Utility source code significantly optimized, work speed increased.
· Unicode support.
· Other improvements and bugfixes.