How to disable semicolons when comparing
teasmith
Posts: 2
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
;
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
There currently is no option to ignore semicolons, such as there is to ignore white space. Please feel free to request this as a feature here:
http://redgate.uservoice.com/forums/141379-sql-compare