Datanamic Data Generator for MS SQL can be used to create realistic test data that you need to verify the behaviour of your database applications. The tool generates data that is appropriate for the database schema (with referential integrity support). The data can be inserted in the database directly or you can generate a SQL script with insert statements.
You define a data generation plan that specifies the details of how you want data to be generated for specific tables and columns. For each column, the tool chooses an appropriate data generator that produces data of a particular type. Note that you can always select another data generator if you want. Datanamic Data Generator for MS SQL includes more than 40 built-in data generators for generating different kinds of data. You can create your own data generators also.
You can save time by using Datanamic Data Generator for MS SQL to generate meaningful test data. You don't have to create your test data manually anymore. When your underlying MS SQL Server database changes, the tool detects that and automatically chooses appropriate data generators so that you don't have to start all over. To further automate your test data generation process, you can use the included command-line utility.