Help with generating data for country table
glozanomoran
Posts: 2
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
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
Comments
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.
Redgate Software