Team Foundation Server 2010 and SQL Compare

SeanRhoneSeanRhone Posts: 13
edited June 28, 2012 9:29AM in SQL Compare Previous Versions
Just set up a TFS SQL 2008 Server project and imported my database and everything builds and seems to work (Used TFS to import the database). I want to user SQL Compare to compare the differences between the database and TFS and create deployment scripts but I'm seeing a lot of "noise" like

TFS does not have the "Grant Execute On.." but SQL Compare does
TFS does not have lines such as "Set Quoted_Identifier OFF" but SQl Compare does.

TFS does not like or allow (as far as I can tell) these sql commands; is there a way to filter them out?


  • Options
    Thanks for your post. Have you looked in the SQL Compare options?

    You can ignore permissions which should hopefully get rid of the "Grant Execute On..." statements and you can also ignore "SET QUOTED_IDENTIFIER" statements.


    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.