Tool to encrypt vendor and customer names.

(0) Share

Report

Posted on by Richard Wheeler

75,730

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

All responses (1)

Answers (1)

Verified answer

Dan Peltier on at

Like (1)

Report

RE: Tool to encrypt vendor and customer names.

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.