unpersonalize a SQL database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

unpersonalize a SQL database

Author

Topic

RMH1972
Starting Member

11 Posts

Posted - 2011-03-11 : 05:14:33

Hello,
I have an question about how to unpersonalize a SQL database
The reason is I work in an hospital and we want to develop an new application on an SQL database, but in this database are patients with all their information like medication and other things
I don’t want to give the development team a copy of this database without atliest changing the name of the patient but there are a lot of patients

Is there a way to do this automatically ?

Greetings

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2011-03-11 : 06:41:08

depending on your tolerence/need for "useful-but-not-traceable" names

update patienttable
set name = X

or

update patienttable
set name = textformofpatientcode

or

update patienttable
set name = buildyourownobfuscatefunction(name)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources