Hi All,
(first post so apologies if any protocol errors)
I have a couple of questions regarding SQL RePermission CmdLine tool (BinaryTree.SqlRepermission.Cmdline.exe) version 20.11.0.2. I am finding there is little information online. My objective is to call the tool in a loop providing instance name and database name each time, rather than using the UI version.
1) Does this tool produce an .SQL file as per the UI version or does it actually execute the re-permissioning?
2) Even when I supply command line parameters -s and -d I am still prompted every time to Enter Server\InstanceName and then SQL username and password. Example input line below.
BinaryTree.SQLRepermission.Cmdline.exe -s "MyInstance" -d "MyDatabase" -m "C:\Path\To\MappingFile.map"
Note this is also the case if I try and launch help via the -h switch.
3) Rather than a single .map file I have a map.gg and a map.usr file pair, exported from ActiveDirectoryPro. Should I form these into a single .map file for use with the command line tool?
Thank you in advance for any clues.