June 9, 2015 at 10:32 pm
I've imported a database schema into VS2013 from a Prod database. After a little bit of cleaning I want to create a test deployment script to confirm there are no differences. However it came back with a long list of SPs that supposedly required changing. Therefore I did a schema compare and again a long list of SP appeared but there was no difference in the body text. After a bit of research I discover the difference was down to the SP properties. In these case the IsSelf property = TRUE in the project, but FALSE in the DB. I believe this is down to having the WITH EXECUTE AS SELF in the SPs.
Question is how can I exclude these differences from the schema compare, and more importantly the generated deployment script as I do not want these SPs re-scripted in every time we make a minor change to the DB?
June 10, 2015 at 12:33 am
Paul Sims-405749 (6/9/2015)
I've imported a database schema into VS2013 from a Prod database. After a little bit of cleaning I want to create a test deployment script to confirm there are no differences. However it came back with a long list of SPs that supposedly required changing. Therefore I did a schema compare and again a long list of SP appeared but there was no difference in the body text. After a bit of research I discover the difference was down to the SP properties. In these case the IsSelf property = TRUE in the project, but FALSE in the DB. I believe this is down to having the WITH EXECUTE AS SELF in the SPs.Question is how can I exclude these differences from the schema compare, and more importantly the generated deployment script as I do not want these SPs re-scripted in every time we make a minor change to the DB?
Can you please describe where the IsSelf property can be found? I don't remember ever seeing it before.
And I get that Schema Compare differences-where-there-are-none nonsense all the time, with procs and with table definitions. I am wondering whether line-ending characters might be playing a part.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 10, 2015 at 2:35 pm
Properties are under each SP and, other objects for that matter, on the schema compare page. It looks something like
> Procedure dbo.xyz
> Properties
IsSelf
June 10, 2015 at 3:45 pm
Actually there is a similar question below with a screenshot to make it clearer. However there is no answer there
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply