Devart Forums

Hi all,

I've downloaded "Data Generator for MySQL" and using it for the trial period.

I'm struggling with the following situation.
In a many-to-many relationship between two tables (entities) I have naturally created an intermediary table with a COMPOSITE primary key and as foreign keys the Primary keys of the other two tables.

The problem is when I use the generator, only the maximum number of records of both tables are created, despite my setting for more records.
Example :

I have table named `system` that I generate 50 records and a table `fault` that I generate 39 records.
In the intermediary table `system_fault` i want to generate 500 records, but only 39 are generated.

Both Primary keys of table `system_fault` uses the generator "Foreign Key (auto assigned)" which is the correct behavior, I think.

Please advise.

Could you please provide us the CREATE definitions of the tables?

You can reply straight to our support system at supportATdevartDOTcom

I've sent you an email concerning this issue.

Thanks!

Thank you for the reply.

Unfortunately, this is not supported yet.

We are planning to support this in the next product version.

We would like to let you know that dbForge Data Generator for MySQL v1.7.12, where composite primary keys are supported, is available for downloading https://www.devart.com/dbforge/mysql/da ... nload.html

Thank you for your help in improving dbForge Data Generator for MySQL.