Generate data for derived column
sbendayan
Posts: 18 Bronze 1
Greetings,
I need to populate test data for certain columns which are derived from other columns in the same table. What is the best way to do this?
For example, I have a column that is derived by concatenating the values of 7 other columns in the same table.
Thanks,
SB
I need to populate test data for certain columns which are derived from other columns in the same table. What is the best way to do this?
For example, I have a column that is derived by concatenating the values of 7 other columns in the same table.
Thanks,
SB
Comments
It might be better to use a Computed Column instead of SQL Data Generator- Data Generator cannot do single column generation - it does whole rows.
https://msdn.microsoft.com/en-us/library/ms188300.aspx
If you do want to generate new rows, or delete the current records and insert new ones, then you can concatenate like that using the "Simple expression generator" https://documentation.red-gate.com/display/SDG3/Generic+generators
Do let me know if you have any questions or issues with that!
Warm Regards,
Technical Sales Engineer
Redgate Software