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

How to disable semicolons when comparing

teasmithteasmith Posts: 2
edited February 17, 2014 6:44AM in SQL Compare Previous Versions
Hello

I am doing a comparison between 2 database, and one of the database always have a semicolon between any END and GO commands, while another does not.

this causes more than 300 differences that shouldn't. How do I resolve this? Thanks.

i.e

CREATE TRIGGER [Data].[TR_I_]
ON [Data].[vA]
INSTEAD OF INSERT
AS

BEGIN

//codes

END

;

GO
CREATE TRIGGER [Data].[TR_U]
INSTEAD OF UPDATE
AS

BEGIN

//codes

END

;

Comments

Sign In or Register to comment.