|
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.
A large number of data generators to choose from, an intuitive user interface and intelligent association of columns with an appropriate data generator. Test data generation with Datanamic Data Generator for MS SQL is easy and painless.
FEATURES:
Datanamic Data Generator for MS SQL is a software tool that generates test data for MS SQL Server databases. It inserts generated data directly into the database, or builds a script with insert SQL statements.
MS SQL Server Connectivity
Direct access to MS SQL databases (with native driver).
Support for multiple MS SQL Server versions.
Supported MS SQL versions: 2000, 2005, 2008.
Data Generation
Generate test data with just a few clicks.
Select the target database and the tables you want to fill and press "Generate test data". Ofcourse you can fine-tune the data generators if desired.
More than 40 built-in data generators.
Datanamic Data Generator for MS SQL includes several built-in data generators for generating different kinds of data. For example, the integer generator provides random integer values, the date generator provides random dates, and the expression/mask generator provides strings that match a pattern that you specify.
Generation of data for multiple tables.
You can select the tables you wish to fill with test data. A Datanamic Data Generator for MS SQL project can hold one or hundreds of tables.
Generates realistic data.
Intelligent use of the expression/mask generator (for for example postal codes) and a large collection of (contry/language specific) lists with names, addresses, cities, streets, etc makes your test data more realistic.
Insert data directly into the database or generate a SQL script with insert statements.
Load data from external sources.
You can load (random, sequantial) data from CSV files or from other tables in the database. Source data that is from a different data type, will be converted automatically.
Generates data that is appropriate for the database schema.
Syntactically correct data is generated for each column.
High performance.
The tool inserts thousands of test data records per second.
Referential integrity support.
Datanamic Data Generator for MS SQL automatically controls referential integrity for linked tables. When data is inserted, it will be done in the correct order. When a child column is part of a relationship it will by default load random data from the parent column in the parent table. Datanamic Data Generator also correctly handles multi-column foreign key constraints.
Advanced data generator settings.
|
Windows Software
Albina Merfyn - I find this to be really easy to use. I can...
