Sample Header Ad - 728x90

Is there a way to add database encryption on certain columns without changing code base?

1 vote
3 answers
923 views
I've experienced a few companies that have various different codebases ranging from 20 year old code without the source anymore to 1 to 10 year old code with the source but thousands of database calls. For certain database fields the companies want to encrypt a column, for example a person's address, without needing to update all the code that calls to that table. They also want the column to still be searchable in where clauses such as "what people are located at 1st street" where the where clause is street like '%1st street%'. Is there a way to easily perform this encryption so that SQL server handles the database encryption and decryption all in the background on the server and not have to change all the code to handle it? If not, what would be the simplest way to accomplish this that would help alleviate massive code changes, unless massive code changes is the only way?
Asked by SolidSnake4444 (111 rep)
Mar 3, 2022, 09:14 PM
Last activity: Mar 13, 2025, 11:44 AM