What are the challenges you face when working across database platforms? Take the survey

Data Generator use production data as source

I am currently testing the Data Generator. It seems pretty straightforward to use however there is one "feature" I cannot find.

I would like to generate a test data set based on the data in our production environment. Basically pointing to  production table and asking for the generator to look up the possible values in each column and populate the test data set based on these values eg. I have a column with the possible values (6,1,14,17,100,200,300,400,500,600,700). 
I know this can be achieved by using the lookup function or regex, but I had hoped i did not have to map every column but rather could point to a production dataset so i only had to alter the columns. Basically, having the generator do the distinct læookup for me and generating the finite data set.
I have tables with more than 100 columns and if rules/lists could be generated for 95% of the columns it would save me a lot of time.

Is this possible or do I have to go through the boring work of mapning all the columns?

Kind regards
Sign In or Register to comment.