EMS Software Pack 25.04.2015

EMS Software is a powerful tool to import data to MySQL tables quickly from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination MySQL data formats for the selected fields, commit options, number of records to skip, etc. Data Import for MySQL includes a wizard, which allows you to set all the MySQL import options for different files visually, and a command-line utility to execute import to MySQL database in one-touch.

Key Features

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
Automatic creation of the table structure
Command-line utility to import data using the configuration file
Powerful visual options module

EMS SQL Query for MySQL is a useful tool that lets you quickly and simply build SQL queries to MySQL databases. Visual MySQL query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to MySQL databases, select tables and fields for a query to MySQL server, set the selection criteria and many more…

EMS Data Generator for Oracle is an impressive tool for generating test data to Oracle database tables. The utility can help you to simulate the database production environment and allows you to populate several Oracle database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more. It has plenty of powerful functionalities to generate Oracle test data in a simple and direct way.

EMS DB Extract for DB2 is an impressive and easy-to-use tool for creating DB2 database backups in a form of SQL scripts. This database script utility allows you to save metadata of all DB2 database objects as well as DB2 table data as database snapshots. Flexible customization of the extract process enables you to select objects and data tables for DB2 database dump and tune many other extract options.

EMS Data Export for Oracle is a powerful tool to export Oracle database data quickly to any of 20 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for Oracle has a friendly wizard, which allows you to set various options of Oracle export process visually and a command-line utility to automate your Oracle export jobs using the configuration file.

EMS Data Import for MySQL is a powerful tool to import data to MySQL tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several MySQL tables or views at once, save all MySQL import parameters set on current wizard session, use special batch insert mode to import MySQL data at the maximum possible speed and much more.

Home Page – http://www.sqlmanager.net/