Need a query for update large database

Question

Hi,

currently i have a table with 80 crore rows data ,I need to obfucate the data in some columns for eg:-If name is 'David Peter' (Same name is used in differnet rows),then i need to update it with some other values like 'ytfr trey'.Now what we do is we have a table with column data like  'ytfr trey' and we are updating randomly the in the table based on rownumber function but this take so much of time .So what i need is a sql query having the logic to update like this eg:-If ABCD is name then i need to update it with CDEF ie two letter difference or some different name but query should update data fastly

Regards

Jon

Answer 1

Use REPLACE...

Answer 2

You can use a column level encryption, where in you would have to create a key for the database.

you can read about it here:

http://msdn.microsoft.com/en-us/library/bb934049.aspx

http://blog.sqlauthority.com/2009/04/28/sql-server-introduction-to-sql-server-encryption-and-symmetric-key-encryption-tutorial-with-script/

http://www.mssqltips.com/sqlservertip/1514/sql-server-2008-transparent-data-encryption-getting-started/

---

Answer 3

Any progress?

Article on obfuscation:

https://www.simple-talk.com/sql/database-administration/obfuscating-your-sql-server-data/

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012