Generate Only One Column

The simplest way to populate your database with test data.

Generate Only One Column

Postby Miron » Sun Sep 15, 2013 3:39 pm

How can I generate only one column in a table.
I want to generate a weight list values based on ID's from other table
Posts: 1
Joined: Sun Sep 15, 2013 3:36 pm

Postby james.billings » Mon Sep 16, 2013 6:37 pm

Hi Miron.

To generate data in just one column, you would highlight the table on the left hand side, then pick "Use existing data source" and point it at the table containing the data you want to keep in another DB.
Then, for each column, you can pick the source data to keep from the top of the "Generator" dropdown list, apart from the column you want random data for. For that column, just pick the generator you want.

The issue I think you will have is that the Weighted List generator doesn't allow you to base it on information from other columns/data - it only works with the data you put into the generator.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests