Data Masking

Question

Post reply

Data Masking

k.thanigaivel

Ten Centuries

Points: 1247
More actions
March 24, 2011 at 3:28 am

#237347

Dear All,
I want to mask the data in development server and same need to get back in to production server. how can i done ?please help me.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

gsc_dba SSCertifiable Points: 5407 More actions · Answer 1

Our company have used this in the past:

http://www.datamasker.com/

Consider this too:

http://www.grid-tools.com/products/fast_data_masking/data_masking_SQL_server.php

gsc_dba

k.thanigaivel Ten Centuries Points: 1247 More actions · Answer 2

thanks gsc_dba

we need scripts or any procedure with out third part software.

brendan.martin Grasshopper Points: 13 More actions · Answer 3

If your looking to do this without the use of a third party tool you should really invest some time into the discovery phase and ensure that you are masking all the data privacy elements.

Check out http://www.datakitchen.com.au/ and look at the methodology for data masking and some of the tools used in the discovery phase. Schema Spy and Talend Open Studio will be a big help for you

Jeff Moden SSC Guru Points: 1004307 More actions · Answer 4

k.thanigaivel (3/24/2011)
Dear All,
I want to mask the data in development server and same need to get back in to production server. how can i done ?please help me.

~~Look up "LIKE" in Books Online. You get to Books Online from SSMS by pressing the {f1} key.~~

{EDIT} Sorry, wrong kind of masking.

If it's truly for sensitive information, you should consider encryption instead of data masking.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)