Generate data in table with Encryption

Hello,
I would like generate data in a database where some columns are with encryption.
So I have VARBINARY (500) where address, phone and other data are encrypter.
I would like create fake data with consistent.
For encrypt I do :
UPDATE Contact SET
        [Phonen1_E] = EncryptByKey (Key_GUID('SymKey'),@Phonen1, 1, CONVERT(VARBINARY, EntityId)),

How I can do that with SQL Data Generator V4?
Who I can put data with my encryption?
Thanks 
Best Regards
Rabbiwan

Tagged:

Answers

  • Unfortunately, I don't think SQL Data Generator can encrypt your data for you.  As a workaround, you could create a table with the equivalent unencrypted columns and then select the data across with a call to your encryption routine.
    Software Developer
    Redgate Software
Sign In or Register to comment.