Generate data in table with Encryption

• 
  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.
  

  sam.blackburn June 26, 2018 09:49

  - 0 +
• 
  I know this is old, but posting my answer if anyone is searching this forum.
  
  I was able to complete this using a custom SQL Command. This example generates a random date somewhere from 01/01/1951 to 01/01/2001, then encrypts it and returns the bit value. This only returns one value so I set the flag to loop for all rows. 
  
  

  DECLARE @dateenc varbinary(128)
  

  SET @dateenc=  EncryptByKey(Key_GUID('SymKey'),CONVERT(nvarchar(10),DATEADD(DAY, ABS(CHECKSUM(NEWID()) % 18615), '1950-01-01')))

  
  

  SELECT @dateencAS dateenc

  JosephIhrke November 20, 2019 22:47

  - 0 +

Add comment

Please sign in to leave a comment.