Ok "BigHelpers" here is the main point,
I guess finally I came out with proper quetion, Please forgive me for any spelling mistakes...I am trying my best to get command on english language.
so, my issue is ..
there are 4 tables called, 1) ClientInfo, 2) ClientAccount, 3) ClientDimension,4) ClientSecurity.
All of them have one common column called "AccountNumber", which PK in ClientAccount table and FK in all other tables.
There already script written by us, whch performs Joins, Stored Procedures and Cursors and retrive the data across these tables based on matching table1.AccountNumber = table2.AccountNumber.
Now, at moment we are in test enviornment, where we do the testing, but while doing that we can see the actual
"AccountNumber" of the clients.
Now , my task is to convert this "AccountNumber" column's data in all 4 tables into encrypted , masked or somthing other form , so that we don't have to make a change in our Joins, Stored Procedures and Cursors , which we are using right now and we can still run them via matching
table1.AccountNumber = table2.AccountNumber, but this time "AccountNumber" data will be in unidentified form.
and only DBA people , can go back or see with some techniques and make references of this unidentified data in "AccountNumber" to actual "AccountNumber" column data.
any suggestion on this , will be a huge huge help from you to me , as always..