Data Generator: Populating multiple tables with same values

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
wnewlandtx
Posts: 1
Joined: Mon 23 Jan 2017 16:32

Data Generator: Populating multiple tables with same values

Post by wnewlandtx » Mon 23 Jan 2017 17:56

I need to generate the same key column data for each of three tables. These four key columns are used to join all three tables. How can I get Data Generator to populate the same key values for all three tables in the same generation load?

alexa

Re: Data Generator: Populating multiple tables with same values

Post by alexa » Tue 24 Jan 2017 13:58

If the tables are linked with a foreign key, you have to select a needed generator for the parent table, whereas the 'Foreign Key' generator for the referencing tables.

If the tables are not linked between each other, you have to select the same generator for all key columns
and specify identical values for the "Random by Seed" field, for example, =1, for the generators in key columns.

Post Reply