How can we help you today? How can we help you today?

Help with generating data for country table

Hello

I did not know how to choose a good title for this topic but let me explain what I am trying to accomplish. We have a country table with the following columns:

- ID
- CountryCode (ISO 3166-1 alpha-2)
- CountryCode (ISO 3166-1 alpha-3)
- NAME

The problem is that per row random data is being generated that are not related. For example we should have a row:

1 - BE - BEL - BELGIUM

But instead we get for each column random data:

1 - ES - POR - CAMEROON

Is there a way to ensure that the generated data is somehow related per row?

Thx
glozanomoran
0

Comments

1 comment

Sort by
  • Rob C
    Hi,

    Unfortunately the three lists of data have unrelated entries so there's no way to use the built in generators to get related data. The easiest thing to do is probably to create your own set of data in a CSV file and use that to generate related data sets - http://documentation.red-gate.com/displ ... +CSV+files

    Sorry.
    Rob C
    0

Add comment

Please sign in to leave a comment.