DataGen

DataGen by DaanSystems is an invaluable addition to the Development Tools suite, specifically under Database Tools. The latest version 0.9 promises efficient insertion of meaningful test data into any database that supports ADO, including popular databases like MS-SQL Server, MySQL, and PostgreSQL. The program file name for easy identification during installation is DataGen.exe and it boasts a minimal file size of 1.5 MB, making it a lightweight yet powerful solution.

One particularly noteworthy aspect of DataGen is its versatility. It supports a variety of ODBC drivers and offers a comprehensive array of features such as the ability to insert identity columns, random data from text files, and regular expression templates. Additionally, it comes furnished with example data files for names, cities, streets, email addresses, and companies, all in multiple languages, to jumpstart your project without hassle. Users can also insert dates and random values from columns from other tables, providing a robust framework for database testing.

Despite being a Shareware product, DataGen ensures excellent value with its capacity to save projects and customize the number of rows to be inserted. Its user-friendly interface makes it accessible to both seasoned developers and those new to database management.

Pros:

• Easy to download and lightweight at 1.5 MB.
• Extensive support for multiple databases like MS-SQL Server, MySQL, PostgreSQL.
• Comes with example datafiles for immediate use.
• Customizable features to insert a variety of data types including dates and random values from other table columns.

You may want to check out more software, such as EMS Data Export 2007 for SQL Server, busTRACE or EMS Data Import 2005 for MySQL, which might be related to DataGen.