Line break and abbreviated keyword detected as changes

darrenm

Just wondering what options there are to stop SQL compare 11 from detecting changes when the only differences in the proc are 'CREATE PROC' versus 'CREATE PROCEDURE' and a line beak before the first input parm.

eg the following is detected as a change:

---
CREATE PROC [dbo].[usp_GetLotsToClose]
@saleVenueId int,
---

VERSUS

---
CREATE PROCEDURE [dbo].[usp_GetLotsToClose] @saleVenueId int,
---

I have 'ignore white space' checked.

Tianjiao_Li

Hi @darrenm ,

I'm afraid there is no such an option to do this at the moment. We appreciate your feedback and would suggest you to add your vote to this post on our user voice forum.

Thanks.