Team Foundation Server 2010 and SQL Compare

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Team Foundation Server 2010 and SQL Compare

Postby SeanRhone » Mon Jun 25, 2012 8:55 pm

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?
SeanRhone
 
Posts: 11
Joined: Mon Jun 25, 2012 8:50 pm

Postby peter.peart » Thu Jun 28, 2012 2:29 pm

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
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest