Red Gate forums :: View topic - Comparing SET options
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Comparing SET options

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
gunneyk



Joined: 09 Oct 2005
Posts: 10

PostPosted: Thu Jun 11, 2009 8:02 pm    Post subject: Comparing SET options Reply with quote

I am comparing two sets of script files and some of the objects such as UDF's similar to this example below: The compare with the SDK runs fine and detects any differences in the UDF itself but not the SET ANSI_NULL's or Quoted ID etc. I have tried various options even no options and it still won't detect the differences in the SET settings. I know this works if I compare two DB's (Not scripts) using SQL Compare. Why doesn't it detect it in this case? Is there a way to do this?


SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (...
DROP FUNCTION [ConvertToBytes]
GO

CREATE FUNCTION [dbo].[ConvertToBytes](@input varchar(50)) RETURNS BIGINT AS
BEGIN
blah blah blah
END
GO

Thanks

Andy
Back to top
View user's profile Send private message MSN Messenger
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Wed Jun 17, 2009 4:08 pm    Post subject: Reply with quote

Thanks for your post.

The issue seems to be that the SET settings are not displayed if they're set to ON. They sync will still work correctly as ON will be assumed if not set to OFF.

However, this can look misleading, and can cause the SQL Differences in reports to line up strangely.

For this reason I have logged it as a bug (SC-4495) with SQL Compare 8.0.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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