detecting create vs alter differences

rchanrchan Posts: 11
edited July 25, 2008 2:35PM in SQL Compare Previous Versions
We are using SQLCompare to compare against a database and scripts folder.

In our scripts for for objects such as Stored procedures, views, functions, we currently use the "IF NOT EXIST... create object ... GO ... alter object" structure to create/alter the object.

This is different than the standard approach of IF EXISTS DROP... CREATE. We don't do the latter approach because we can't risk accidently losing permissions on this object (from the DROP statement) when deploying this to production.

However, SQL Compare will always complain about a difference in this object due to the difference in "CREATE" versus "ALTER".

Any suggestions on how to get SQL Compare to NOT report a difference?
Thank you



FROM dbo.sysobjects
WHERE id = OBJECT_ID(N'ufn_MyFunc') AND xtype IN (N'P', N'V', N'FN', N'TF', N'TR'))
EXEC('CREATE FUNCTION ufn_MyFunc() RETURNS varchar(5) AS BEGIN return ''empty'' END')

... etc...


  • Options
    I'm sorry to say that there isn't a method to pass a pragma or change this part of the scripting at present. However I will pass your request to the developers for assessment for possible inclusion.
    Chris Buckingham
    Red-Gate support
  • Options
    jamaljamal Posts: 47 Bronze 3
    Yes, we are also thinking of using this method to store object definitions in source control. We'd like to use sql compare to compare our source control scripts to what's on a given server, however, sql compare marks the objects as different because what it gets from the server has CREATE and what it gets from source control says ALTER. That is the only difference. Is there an option to ignore these differences?
Sign In or Register to comment.