Software Testing Tools Blog – Testertools

forSQL Data Generator is an automatic data generator for a large scale of database testing and Quality Assurance. It helps database developers and testers to automatically generate test data to fill a database with logically correct and realistic test data. This saves countless hours and even days that would otherwise be wasted on entering and configuring the data manually.

forSQL Data Generator is easy to get started with. You should create a project that contains the information about a database, tables and fields. Then it is necessary to select the fields for testing and the method how to fill these fields. Once the configuration is over, the program is ready to generate test data. Simplicity and ease of use make the program a must-have tool for those developers who want to save efforts and time in database testing.

The best in forSQL Data Generator is its universality. Not only does it work with only one server, the program can also work with various servers using ODBC. Another best feature in forSQL Data Generator is an ability to fill fields using several different methods that range from random values to filling real data (like names of US cities) from templates. forSQL Data Generator automatically reads the information about the structure of a database, primary and secondary keys, which considerably simplifies database configuration.

List of way to generate data:

* Generate data from files with the really data (for example – list of USA city)
* Generate random data
* Generate data by format
* Genereate constant data
* Generate data from list
* Generate incremental data
* Generate data as result of SQL script

List of supported servers are:

* MS SQL server;
* Oracle;
* Interbase/Firebird;
* MySQL;
* Sybase;
* Informix;
* DB2;
* Paradox;
* Access;
* DBF/FoxPro;
* any other servers, which have connection via ODBC;

Click here for more info.