Baselining and Version Control
To be familiar with our usage of SQL Compare, here's my procedure:
1 - Baseline the database and save as a snapshot using SQL Compare
2 - Deploy new code
3 - Run comparison between baseline and new database version
4 - Print and verify all differences
5 - Create a new baseline
When following this procedure, however, I am not made aware of object level permission changes. I can do it (tediously) by using sp_helprotect, but I'd really love to use SQL Compare as one stop shopping Any suggestions?
If this isn't possible in the latest version, can we get it included in an update or next version?