jdbfill

Jdbfill is a simple and lightweight command line application designed to help you easily populate a database without any user intervention. The tool can come in handy when you are testing a data-aware app, particularly since this can be quite a time-consuming task. In the aforementioned example, testing the tool you are working on with real data is critical and since, you cannot fill in the data manually, a generator tool can save you a lot of time and energy.

An advantage of using an automated test data generator is that the amount of data you can use is considerably higher, thus making your application more reliable.  Moreover, the testing process is accelerated and it can lead to better results. Then again, perhaps the best perk of the automation is that the database can be populated without any human interaction and even in the off hours, thus it can help you stick to a strict schedule.

Generally speaking, there are commercial tools out there that can achieve all this, but at a high cost. Jdbfill is a free open source tool that and hence, you do not need to worry about costs. However, you should bear in mind that it works in specific frameworks, namely PostgreSQL and MySQL. To get started, connect to the server and hit the command for populating the database.