Devart Forums

Just trying the Data Generator tool and can't figure out how to do what I need. Not sure if it can, but here's what I'm trying to do -

Generate Data for a Table that has 2 foreign keys BUT I don't want to truncate and generate those tables. I would like to have the Data Generator used the existing tables (data) to populate the FK fields in the new generated data.

Hope that make sense, and is their some way to do that?

Thanks

Sandy

As a follow up I found that you can populate a field with a SQL query but the Data Generator crashes on generation (Exception report sent)

Simple Query Used

select id from make order BY rand() limit 1;

Similar query for the other FK's

Sandy

Just trying the Data Generator tool and can't figure out how to do what I need. Not sure if it can, but here's what I'm trying to do -
Generate Data for a Table that has 2 foreign keys BUT I don't want to truncate and generate those tables. I would like to have the Data Generator used the existing tables (data) to populate the FK fields in the new generated data.
Hope that make sense, and is their some way to do that?

In order not to truncate the related tables, you have to set the focus on the table names and unselect the option 'Truncate data from table before generation' in the table generation settings.

As a follow up I found that you can populate a field with a SQL query but the Data Generator crashes on generation (Exception report sent)
Simple Query Used
select id from make order BY rand() limit 1;
Similar query for the other FK's

We are aware of this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

Thanks, I did figure out how to force it to not truncate the table but due to the crash I was unable to get any further.

Look forward to the fix so I can try it out.

Sandy