Options
Team Foundation Server 2010 and SQL Compare
SeanRhone
Posts: 13
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?
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?
Comments
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569