Data Solutions and Program Functions Software for Windows

Altova DatabaseSpy
$129 - Altova, Inc.

Altova DatabaseSpy 2008 is the unique multi-database data management, query, and design tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes connections and related project files to make accessing your databases and their components effortless. You can even open connections to multiple databases at once. It clearly presents tables, views, stored procedures, and data in easily negotiable windows, and it also lets you directly edit database content. DatabaseSpy's SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop editing, and more. You can easily write SQL scripts that retrieve data from multiple tables, and results can be displayed in individual, named windows for maximum clarity. DatabaseSpy's powerful Database Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to duplicate existing structures in differing database types. DatabaseSpy supports IBM DB2 (including IBM pureXML databases), Microsoft SQL Server, Microsoft Access, Oracle, MySQL, and Sybase, as well as other ADO or ODBC databases. XML support includes advanced capabilities to inspect XML data in database tables and to manage the XML Schemas used to validate that data. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and it imports data from CSV files. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. It is the one tool to finally liberate data management. Do data differently! Download Altova DatabaseSpy 2008 today, and try it free for 30 days.

---

---

EMS Data Pump 2006 for DB2
$95 - EMS Database Management Solutions, Inc

EMS Data Pump for DB2 is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL Server, or any other database with ADO support) to IBM DB2 databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target DB2 database and select tables for import. Database conversion becomes as easy as possible with DB2 Data Pump!

Key Features:

- User-friendly wizard interface;
- Converting database structure and data from any SQL servers or local databases, which have an ADO provider;
- Ability to create a new database or connect to the existing one;
- Selecting source tables, fields and indices for conversion;
- Fast generation of tables, fields and indices according to the source database structure;
- Easy customization of target database objects options;
- Ability to view and edit and save SQL script for generating target database;
- Full monitoring of database generation process;
- Selecting tables and their fields for data import;
- Multilanguage support.

---

---

Data Manager for Excel
$49.95 - Datasoft Solutions

Transform Excel into a fully functional database application with this powerful Excel add-in. Data Manager allows you to convert worksheets into tables, conduct queries, and create forms for data entry all within the Excel environment. It offers a wide range of data validation options to ensure that only valid data is added to your database. Using customized buttons that can be added to your forms, you can open other forms, run macros, and open hyperlinks to files or internet addresses. Because the software is integrated into Excel, you can take advantage of Excel's numerous database related features to analyze your data. For those who currently store data in Excel Data Lists, Data Manager enables you to quickly and easily convert those lists into Data Manager tables. If you have Microsoft Word, you can use its Mail Merge, as well as Data Manager's Send Data capabilities, to create form letters, mailing labels, envelopes, directories, e-mails and fax distributions with the data from your Data Manager database.

---

EMS Data Generator 2005 for MySQL
$95 - EMS Database Management Solutions, Inc

EMS Data Generator for MySQL is a powerful utility for generating test data to several MySQL database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

Features:

- User-friendly wizard interface;
- Generating data to several tables from different databases on one host;
- All MySQL data types support including ENUM and SET types;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Wide variety of generation parameters for each field type;
- Ability to set NULL values for certain percent of cases;
- Possibility of saving all the generation parameters, set on current wizard session;
- Command-line utility to generate data using the template file.

---

EMS Data Generator 2005 for Oracle
$95 - EMS Database Management Solutions, Inc

EMS Data Generator for Oracle is a impressive utility for generating test data to several Oracle database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

Features:

- User-friendly wizard interface;
- Generating data to several tables from different schemas of database;
- Support for generic Oracle data types including numeric, character, datetime (DATE, TIMESTAMP), intervals and binary (RAW, LONG RAW, BLOB) types;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Wide variety of generation parameters for each field type;
- Ability to set NULL values for certain percent of cases;
- Saving all generation parameters set on current wizard session;
- Command-line utility to generate data using the template file.

---

EMS Data Generator 2005 for PostgreSQL
$95 - EMS Database Management Solutions, Inc

EMS Data Generator for PostgreSQL is a powerful utility for generating test data to several PostgreSQL database tables at once. The wizard application allows you to define tables and fields for generating data, set value ranges, generate char fields by mask, load values for BLOB fields from files, get lists of values from SQL queries and many other features to generate test data in a simple and direct way. It also provides you console application, which allows you to generate data in one-touch by using generation templates.

Features:

- User-friendly wizard interface;
- Generating data to several tables from different databases on one host;
- All PostgreSQL data types including array, network address and geometric types;
- Different generation types for each field including list, random, incremental data generation and more;
- Ability to use SQL query results as list of values for data generation;
- Automatic control over referential integrity for linked tables data generation;
- Wide variety of generation parameters for each field type;
- Ability to set NULL values for certain percent of cases;
- Possibility of saving all the generation parameters, set on current wizard session;
- Command-line utility to generate data using the template file.

---