Encerrado

Double-table test data generator

I need a program, in Delphi, which would fill two identical tables in two database with large amount of random test data, almost identical for the two databases except for a specified number of randomly distributed differences.

There are tools on the market which do similar job (e.g. [url removed, login to view]), but

only for one table, of course. I need two tables filled with slightly different data in order to test performance and limitations of my data comparison product.

So far the test data generator is for in-house use only, so there is no need for a production quality UI, it just needs to be usable. On input, I need to specify:

* The two databases to be used (standard connection dialogs);

* Name of the table (supposed to be the same in both DBs)

* the total number of records generated;

* Number of records missing in 1st table (that is, only inserted into the 2nd one),

* Number of records missing in 2nd table,

* number of changes in column values

* an average size of BLOB data (if any)

* an average size of VARCHAR data (in % of max size)

------

[Added 26 Dec 2003]: I thought I'd rather specify in more details how I expect the random data for a new record to be

generated. Columns of the target table are displayed in a TListBox, I can select any column and configure how data

for it is generated:

- Numeric: random numbers, Min and Max limits can be specified

- Bit (0 or 1): probability of getting 1 is specified

- Strings:

a) as random sequences of printable characters

b) as randomly selected line from a specified text file

- GUIDs (uniqueidentifier): using CoCreateGUID

- Dates: random in a selected range (?)

For any of the types (except for BIT, obviously), the ability of taking values, randomly, from a choosen lookup table in the same database would be a big advantage.

------

On output, I need a log of the exact changes made and the two tables filled with data.

## Deliverables

1) Complete and fully-functional working program, in Delphi 6, in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

Further details:

The program should analyze the table structure and be able to generate some reasonable random values for each of the common types. No need to do anything about the foreign keys (assume there aren't any), but at least IDENTITY fields must be properly handled.

As I see it, the program should prepare a record in memory, then pull some random numbers and decide if any modifications should be made to the record, then add it to either one of both tables.

The program must not be DBMS-specific. First of all, it must work for MS SQL Server, but I don't see any reason why it should not work on any other database available via standard ADO or BDE access layers of Delphi.

## Platform

Windows 2000/XP/ME, with any database supporting

Habilidades: Delphi, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: ado data generator, why data structure, use of data structure, types of data structure, types data structure, test data generator, test code generator, tables in data structure, table data structure, strings for c standard, php code generator software, performance test job, new data structure, ms lookup, min range, generator log, different types of data structure, different types data structure, data structure types, data structure.com, data structure code, data structure and c, c with data structure, c using data structure, c test generator

Acerca do Empregador:
( 6 comentários ) Russian Federation

ID do Projeto: #3030539

18 freelancers estão ofertando em média $119 para este trabalho

teknowmagic

See private message.

$85 USD in 7 dias
(124 Comentários)
6.8
justserg

See private message.

$85 USD in 7 dias
(143 Comentários)
6.8
bradaric

See private message.

$212.5 USD in 7 dias
(89 Comentários)
6.7
BearInUA

See private message.

$85 USD in 7 dias
(14 Comentários)
4.3
vprovw

See private message.

$127.5 USD in 7 dias
(6 Comentários)
3.2
dushyantsharmavw

See private message.

$127.5 USD in 7 dias
(9 Comentários)
2.9
dferin

See private message.

$93.5 USD in 7 dias
(12 Comentários)
2.3
masterofpcsvw

See private message.

$85 USD in 7 dias
(2 Comentários)
1.9
korsarvw

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
alexpetrovvw

See private message.

$102 USD in 7 dias
(0 Comentários)
0.0
nshah

See private message.

$127.5 USD in 7 dias
(0 Comentários)
0.0
vasilpahomov

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
mihajlovw

See private message.

$102 USD in 7 dias
(0 Comentários)
0.0
byteinformatica

See private message.

$255 USD in 7 dias
(0 Comentários)
0.0
sslavnic

See private message.

$85 USD in 7 dias
(0 Comentários)
0.0
sunsetvw

See private message.

$127.5 USD in 7 dias
(0 Comentários)
0.0
danmincu

See private message.

$93.5 USD in 7 dias
(0 Comentários)
0.0
kenankilictepe

See private message.

$187 USD in 7 dias
(0 Comentários)
0.0