Red Gate forums :: View topic - Encrypted Columns
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Encrypted Columns

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Matt_F



Joined: 23 Jun 2012
Posts: 2

PostPosted: Sat Jun 23, 2012 7:24 pm    Post subject: Encrypted Columns Reply with quote

Is it possible to generate data for encrypted columns where the data has been encrypted using SQL Server symmetric keys?

For example, could realistic data be generated and then encrypted using the specified symmetric key for FirstName and Surname columns in a customer table.

I think this may be possible using a custom generator, however I can't see how I could specify the symmetric key to be used.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Jun 25, 2012 8:54 pm    Post subject: Reply with quote

I might have misunderstood, but if you generate data for a encrypted column, then as long as the account that you use to generate the data has access to the key and certificate then the newly inserted data would be encrypted.

However, I haven't really played around with encrypted columns, so I don't know that this is definitely correct.

If you manually insert a row to you encrypted column, is it automatically encrypted, or does it only encrypt if you insert in a certain way?
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Matt_F



Joined: 23 Jun 2012
Posts: 2

PostPosted: Tue Jun 26, 2012 9:03 am    Post subject: Reply with quote

Thanks for the reply Chris.

The data is only encrypted when inserted through a stored procedure which takes the incoming parameters, encrypts the data and then inserts.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Fri Jun 29, 2012 11:38 am    Post subject: Reply with quote

Sorry for the delay.

You're right then; I think this could only be done through a custom generator.

You might be able to do it with a SQL Statement generator pulling the unencrypted data from another table and then inserting it thought the sp, but I haven't ever tried it myself.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group