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
Data Generator
Re: Data Generator
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
Sandy
Simple Query Used
Similar query for the other FK'sselect id from make order BY rand() limit 1;
Sandy
Re: Data Generator
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.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?
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.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
Re: Data Generator
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
Look forward to the fix so I can try it out.
Sandy