SQL Compare scripted the schema and role creation out of order. Below is a snip of the beginning of that script. I was using SQL Compare 10.1.0.102 and comparing script folder --> SQL 2008R2 database. Also, I can see that Role creation doesn't have the error check found after all the other actions... though I'm not even sure if a role can be rolled back as I havn't tested. I'm not sure where to report this so here it is:
Add comment
Please sign in to leave a comment.