The DTM Data Generator File and converting from Redgate

Powerful and fully customizable utility that generates data for database testing purposes

Moderator: Support Team

The DTM Data Generator File and converting from Redgate

Postby Matthieu » Wed Apr 25, 2018 12:57 pm

Hello

I had previously been using Redgate with MS SQL Server in order to generate data. I will be changing to PostgreSQL to manage my database and so would like to begin using DTM Data Generator.
Is someone able to provide some detail as to what each line means within the DTM Data Generator project file (.dgp)?
Specifically, the lines for each seperate data generation tab. For example, what is Method#= and what do all of the numbers refer to ?

Equally, does anyone have any advice on switching from Redgate and an easy method for doing this?

Many thanks
Matthieu
 

Re: The DTM Data Generator File and converting from Redgate

Postby Support Team » Wed Apr 25, 2018 3:31 pm

Matthieu, unfortunately it is not a public information. I can provide you some details but not sure about this information stability.
Method means fill method of the rule. There is list of available methods:

FM_RANDOM=0,
FM_TABLE=1,
FM_LIST=2,
FM_LIST_FILE=3,
FM_IGNORE=4,
FM_LIBRARY=5,
FM_INCREMENTAL=6,
FM_MASK=7,
FM_SQL=8,
FM_REGEXP=9,
FM_GROUP_ITEM=10,
FM_NAMED=12,
FM_EXCEL=13,
FM_XML=14,
FM_JSON=15,
FM_SCRIPT=16;
Support Team
 
Posts: 257
Joined: Sun Mar 26, 2006 3:48 pm

Re: The DTM Data Generator File and converting from Redgate

Postby Support Team » Wed Apr 25, 2018 3:35 pm

Also, there is no easy way to convert your project.
As far as I understand the reason is the different model: in our data generator you can create any number of rules for some table and do not create for another one.
But Redgate's structure is associated with database schema directly. It is a too important difference.

I recommend you run our Rule Wizard in "Data By Example" mode. It will analyze existing test data and attempt to create a set of rules with similar properties.
After that, you will be able to review it.
Support Team
 
Posts: 257
Joined: Sun Mar 26, 2006 3:48 pm

Re: The DTM Data Generator File and converting from Redgate

Postby Matthieu » Thu Apr 26, 2018 7:49 am

Hello

Thank you for your advice! I will see if I can use Data by Example as much as possible.

Regards
Matthieu
 

Re: The DTM Data Generator File and converting from Redgate

Postby Support Team » Thu Apr 26, 2018 8:09 am

In any case, please let us know about difficulties in your migration.
My colleagues from R&D dept can improve mentioned functionality if necessary.
Support Team
 
Posts: 257
Joined: Sun Mar 26, 2006 3:48 pm


Return to DTM Data Generator, Flat File Generator and Test XML Generator

Who is online

Users browsing this forum: No registered users and 2 guests

cron