Why doesn't Data Compare allow the user to run it as a different user? I can SHIFT + right click and get the option to "Run as different user" for SQL Compare, but not Data Compare. My standard login has limited access for security reasons so I need to switch to my administrator account for many actions like this.

Thanks,
Jason
pjingram33
0

Comments

4 comments

  • Mike U
    I can't think of any reason why you wouldn't be able to do that. Data Compare should be exactly the same as Compare. Can I ask what you're right-clicking on to get the 'run as' option?
    Mike U
    0
  • pjingram33
    In Windows 7 a "SHIFT + right-click" will bring up a menu with a "Run as a different user" option. Saves time from launching from the command prompt. Either way I found the issue. The shortcut the installer places for SQL Data Compare under Start -> All Programs -> Red Gate doesn't have a target listed. SQL Compare does however. I fixed the shortcut for Data Compate to have a target and now I get the expected options.
    pjingram33
    0
  • Mark J
    Thanks for the description - we'll take a look and see if there's something simple we just need to fix in the installer
    Mark J
    0
  • Pixelated_1
    F.Y.I this is still a problem for SQL Data Compare version 11.3.0.7. To work around it I deleted the shortcut created in start --> 'all programs' --> 'Red Gate' and copied in a new shortcut created from C:Program Files (x86)Red GateSQL Data Compare 11RedGate.SQLDataCompare.UI.exe.
    Pixelated_1
    0

Add comment

Please sign in to leave a comment.