Comparing SET options

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Comparing SET options

Postby gunneyk » Thu Jun 11, 2009 8:02 pm

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
gunneyk
 
Posts: 10
Joined: Sun Oct 09, 2005 9:58 pm

Postby Chris Auckland » Wed Jun 17, 2009 4:08 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests