Options
Compare Stored Procs without comparing permissions
Bellisio
Posts: 26
I am trying to compare a database between a production and a training server; I keep coming up with all stored procs as being different, but as I look thru them, it seems the only difference is that there are different accounts that execute them on prod vs. training.
EX: production has account named xyz that uses the stored procs, but training has account named abc.
Trouble is, I won't see any procs that actually have differences in the code portion this way.
I would like to exclude the permission checking when comparing the stored procs, and compare the code only - is this possible?
EX: production has account named xyz that uses the stored procs, but training has account named abc.
Trouble is, I won't see any procs that actually have differences in the code portion this way.
I would like to exclude the permission checking when comparing the stored procs, and compare the code only - is this possible?
Comments
Thanks for your query. Have you tried selecting the "Ignore permissions" option, as described in
http://www.red-gate.com/supportcenter/C ... c52647.htm ?
David Atkinson
Red Gate Software
Product Manager
Redgate Software
Some of our options are set at the application level and some are set (and preserved) at a project level, which is why they are found in different places. Where would you have wanted for these options to be found? We're always looking for ways of improving the usability and discoverability of our features.
Kind regards
David Atkinson
Red Gate Software
Product Manager
Redgate Software