SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

TDE Decryption Timer Script

By Edward Pochinski,

At our company we Santize data from production to move to development environments. What I did was automated the entire process from backup, restore with cert\key to a "Sanitize" server, pull in a sanitization or masking script to mask the data. Remove the encryption to peform the final backup of the masked data to a Sanitized directory and move to the development server. The script can also be used to let you know when the encryption process has completed to move to a next step automating tasks. This turned out to be quite useful for the automation process I coded up. I hope you may find some use for the code at you shop.

Total article views: 320 | Views in the last 30 days: 2
 
Related Articles
FORUM

want to automate the restoration process

want to automate the restoration process

FORUM

Email Automation

Automate EMail process from SQL Server

FORUM

automate the process of database uploading from local system to dbsever

automate the process of database uploading from local system to dbsever

FORUM

Automation Solution for Deadlock

How to automate to kill the processes when they are blocked

FORUM

Sanitizing the data

In terms of SQL, what does it mean by sanitize the data....I read couple of article and have some id...

Tags
availability groups    
decryption    
encryption    
tde    
 
Contribute