Data Generator - Composite primary key

[gtaranti]

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.

[alexa]

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

You can reply straight to our support system at supportATdevartDOTcom

[gtaranti]

I've sent you an email concerning this issue.

Thanks!

[alexa]

Thank you for the reply.

Unfortunately, this is not supported yet.

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

[alexa]

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.