Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

existing column Level encryption in sql server2008 Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 11:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 4:27 AM
Points: 71, Visits: 322
Hi,
how to set the column level encyption in sql server 2008 in production enviroment without drop existing column and what are method available for encrypt the data in sql server 2008 standard edition.
Post #1432473
Posted Tuesday, March 19, 2013 1:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 223, Visits: 1,730
Coolroof (3/18/2013)
Hi,
how to set the column level encyption in sql server 2008 in production enviroment without drop existing column and what are method available for encrypt the data in sql server 2008 standard edition.

Column level encryption is available from express edition.
All encryption method generate a varbinary as output so you probably must add a new column of varbinary type, encrypt the data, remove the old not encrypted and make appropriate change to application/sp to use column level encryption.
Example http://msdn.microsoft.com/en-us/library/ms179331%28v=sql.105%29.aspx/
Post #1432511
Posted Thursday, March 21, 2013 1:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 4:27 AM
Points: 71, Visits: 322
without creating varbinary column not possiable..?
Post #1433610
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse