complete backup of database except values in a particular column of a table

What if we want to take complete backup of
production database except values in a particular column of a table.
Suppose if
we don't want to reveal social Security number of employees . Can we
take a backup to send the offshore team with no data in SSN column of
employee table.Unfortunately, you can't do that in a backup.
What I have done before is make a copy of the database, and then execute
some 'scrubbing' scripts that would make the appropriate data alterations.
Things like changing Staff names to 'Staff', SSN to 'XXX-XX-XXXX', etc.
With SQL 2005, there are several encryption options available. But if
someone will have physical possession of the database, and a lot of time,
I'm still not ready to completely trust encryption.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Arun" <toarunmishra@.gmail.com> wrote in message
news:1156974085.063812.206780@.m79g2000cwm.googlegroups.com...
> What if we want to take complete backup of
> production database except values in a particular column of a table.
> Suppose if
> we don't want to reveal social Security number of employees . Can we
> take a backup to send the offshore team with no data in SSN column of
> employee table.
>|||Hi,
For client specific data we normally take a back of the database and restore
in a new name and do some data masking manually
and then take a backup and send to offsite. Ensure that you mask the
critical info before you send.
Thanks
Hari
SQL Server MVP
"Arun" <toarunmishra@.gmail.com> wrote in message
news:1156974085.063812.206780@.m79g2000cwm.googlegroups.com...
> What if we want to take complete backup of
> production database except values in a particular column of a table.
> Suppose if
> we don't want to reveal social Security number of employees . Can we
> take a backup to send the offshore team with no data in SSN column of
> employee table.
>