What are the challenges you face when working across database platforms? Take the survey
Options

Line break and abbreviated keyword detected as changes

darrenmdarrenm Posts: 1 Bronze 1
edited October 17, 2017 8:03AM in SQL Compare
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.



Tagged:

Answers

Sign In or Register to comment.