|
|
|
Test Database. Why do you need it?
|
There are two main stages of any IT product lifecycle: development (includes
design, coding, testing, etc) and maintenance. At the first stage you have no data that developers can use.
The first reason is that you have no data at all before launching the information system.
The second is that the existing data is confidential and developers are not allowed to access it.
DTM Data Generator (download) helps you create test database in both cases.
The test database generator can populate empty database as well as hide critical data from existing database by scrambling.
Realistic test database enables developers to make IT solution better. They can use realistic
data without any fear of production data destruction or disclosure. So, the generator offers two ways to handle the test database.
The first is to create new data in the empty database. The second is to create test database based on existing
tables by scrambling personal information or confidential values.
|
|
|
There are a few methods to fill in the fields of your test database.
Most important are random data generator, by another database table or query, by predefined value list, incremented and by mask.
The Value Library allows to select test database items from predefined lists of well known data like geographic data or first names.
The data generator has Rule Wizard that helps the user to make realistic test database by a few clicks.
It generates set of rules based on database structure: table columns (name and data type), relationships, constraints, etc.
DTM Data Generator is database independent. It supports ODBC, OLE DB, IDAPI and Oracle Call Interface.
These unified access methods enables that user to populate MS SQL Server test database as well as Oracle database or DB2.
See also
|
|
|
•