The Filltabl is a DB-Library-based, Win32 console utility that you can use to generate a large amount of data for a table. Filltabl queries SQL Server's catalog to learn the structure of the table, generates pseudo-random data values, and inserts the data into the table by using the DB-Library bcp API. Filltabl generates enough data values to fill the table with the number of rows you request. It even populates variable-length columns, such as varchar, text, or image columns, with variable amounts of data.
Since the data values generated by Filltabl are random, duplicate values are occasionally generated, especially for numeric data types. This can prevent Filltabl from filling tables with unique indexes or constraints, especially on numeric columns.
Filltabl is provided with its source code. If you have a DB-Library development environment, you can customize Filltabl.