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
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?
- Posts: 11
- Joined: Mon Jun 25, 2012 8:50 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.
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
- 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 0 guests