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

Is it possible to generate data for only selected columns in a SQL Server table?

I am attempting to use the data generator to provide data for selected columns in a table. I do not want it to generate and replace data for all columns in a table, just some.


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    What you are seeking using SQL Data Generator is possible, however it will mean creating a copy of the database as you will be removing the column data permanently.

    This SQL Data Generator help document explains the steps required.

    Another alternative, if you are actually looking to mask data for a particular column, would be to use another Redgate Product called SQL Data Masker, further information is available here and the help documentation for SQL Data Masker is here.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.