Attempting to implement On-The-Fly/In-Flight masking for SQL Server DB after an upgrade. Created a batch file (Export, Import) as per the process mentioned in documentation. But while executing the batch file, an error was generated when trying to execute SQLCMD. Below is the actual error.
'SQLCMD' is not recognized as an internal or external command, operable program or batch file. Error creating masked views.
How do we troubleshoot this and ultimately resolve this error?
Scramble database was a much earlier database.
The issue here seems to be twofold
1) if SQLCMD is not recognized, please make sure the SQL Server client software is installed correctly and appropriate directories are on the path, SQLCMD is usually in directory C:\Program Files\Microsoft SQL Server\100\Tools\Binn
2) The version of Subset and the version of the scramble database are out of synch, either reinstall scramble from the latest install kit or use the attached SQL file to recreate the charhash function