Comments
Sort by recent activity
I am also trying out SQL compare but this question is for development using the SQL Source Control. The issue is that the DB has a number of old views and stored procedures that are saved if you would run them today on the original DB it will also fail but the SQL Source Control added them to be run. I am trying to test the source control functionality and after creating a new DB the views and SP fail and I assume the transaction is rolled back. My question is if there is a setting or a way I can run the "get latest" and it will commit all scripts that did not fail. Then I can come manually and fix the ones that did not work. What I did right now is I put all the failing stuff into the filter to be ignored.
Second I would like to know if I can create a filter checking the actual script i.e. if it contains "FROM dbo.Lots" it should be exclude.
Thanks for your help
Eli / comments
I am also trying out SQL compare but this question is for development using the SQL Source Control. The issue is that the DB has a number of old views and stored procedures that are saved if you wo...