Red Gate forums :: View topic - How to disable semicolons when comparing
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

How to disable semicolons when comparing

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
teasmith



Joined: 14 Feb 2014
Posts: 1

PostPosted: Fri Feb 14, 2014 4:31 pm    Post subject: How to disable semicolons when comparing Reply with quote

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

;
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Feb 17, 2014 12:44 pm    Post subject: Reply with quote

Hello,

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group