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

CNEAGLE1CNEAGLE1 Posts: 2 New member
in SQL Data Generator
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.
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi,
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.