Team Foundation Server 2010 and SQL Compare

SeanRhone

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?

peter.peart

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.

HTH,

Pete