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.
| Author |
Topic |
|
rjcurro
Starting Member
4 Posts |
 Posted - 2009-05-15 : 17:05:04
|
| I've got a multiple tables that the user wants to export and backup, but before they export some of the data needs to be removed because of confidentiality. I was thinking of storing the scrubbed tables into a temporary table than backing that up. Unfortunately I'm not sure how to do this. What the best way to do this?thanks,Robert. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-16 : 03:08:58
|
| cant you use some scrambling algorithm to scramble the sensitive data before you export it? |
 |
|
|
|
|
|
Backup temporary tables