One of our clients has cloned their GP server for development purposes. They want to encrypt the vendor and customer names on this development server. Does anyone know of a tool that could change all of these?
*This post is locked for comments
One of our clients has cloned their GP server for development purposes. They want to encrypt the vendor and customer names on this development server. Does anyone know of a tool that could change all of these?
*This post is locked for comments
Hi Richard,
Are you looking for actual encryption?
docs.microsoft.com/.../encrypt-a-column-of-data
Or are you just trying to mask the names from being recognizable?
If the main goal is to just to hide the names from being recognized, an update statement with a substitute cipher on the letters would work too. (Replace all A's with J's, all B's with R's, etc.)
I don't know of any tools that do this, but here's a few manual options.
Almas Mahfooz
3
User Group Leader