Automate and integrate using the SQL comparison API
Moderator: Chris Auckland
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
SET QUOTED_IDENTIFIER ON
IF EXISTS (...
DROP FUNCTION [ConvertToBytes]
CREATE FUNCTION [dbo].[ConvertToBytes](@input varchar(50)) RETURNS BIGINT AS
blah blah blah
- Posts: 10
- Joined: Sun Oct 09, 2005 9:58 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.
- 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