This tool helps generate simulated data for SQL Server database with data of the specified type.
Datanamic Data Generator for MS SQL can be used to create realistic test data that verify the behavior of your database applications. The tool generates data that conforms to the design and appropriate to the type of data expected in the specific fields. The data can be inserted in the database directly. An alternate method available is to generate a SQL script with insert statements. The interface is quite intuitive and simple to use. Using it you define a data generation plan. This plan specifies the details of how you want data to be generated for specific tables and columns. The application ties a suitable data generator of a specific data type to the column selected. This automatic linking is one of the most useful feature of the tool.
There is no need to be restricted by the default, you can change the generator. The application provides some 40 built-in data generators. The user can create his own generator too. There is no need for creating large volume of data manually, which could be quite tedious. To further automate your test data generation process, you can use the included command-line utility. For most of the options to be selected to set up the data generation process, you are helped along by drop down lists. This is a simple yet useful tool that a relative newcomer also would be able to operate effectively.