The customer has Migrated Some Real Data in Dev Environment and is looking for a way to anonymize the data. Since this is a standard request in Eurpean Region but not for FSM, we are looking for a Script that can be used in Cloud Environment to anonymizethe Data.
Solved
Anonymize the data
+13Best answer by Lee Pinchbeck
Hi
There are a scripts to anonymise the data packaged with the FSM installer. They can be found at the following default file path C:\Installs\FSM6_0_0_U13\DatabaseData\SQLServer\FSM6_Truncation.
The script as it comes will delete everything so it must first be reviewed and the elements you wish to retain commented out of the script so that they are not deleted.
If you are referring to a different type of data clean up then we would need specifics to address how to potential achieve that.
Kind regards,
Lee Pinchbeck
Ann DeGroat
This topic has been closed for replies.
+11Hi
have you got any update about this topic?
~Juni
+13I have not
+28
+24Hi
There are a scripts to anonymise the data packaged with the FSM installer. They can be found at the following default file path C:\Installs\FSM6_0_0_U13\DatabaseData\SQLServer\FSM6_Truncation.
The script as it comes will delete everything so it must first be reviewed and the elements you wish to retain commented out of the script so that they are not deleted.
If you are referring to a different type of data clean up then we would need specifics to address how to potential achieve that.
Kind regards,
Lee Pinchbeck
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.