Monday, June 29, 2009

Using Beyond Compare in Visual Studio Team Foundation Server for Comparing and Merging

This is how you get Beyond Compare working for comparing/merging in TFS. The default viewer is not as great as beyond compare so it comes very handy when you change to bc.

In Visual Studio do the following:

  • Click on Tools menu
  • Click on Options menu item
  • Expand Source Control tree item
  • Select Visual Studio Team Foundation Server tree item
  • Click on Configure User Tools... button
  • Click the Add... button
  • For Extension, type * (for all files)
  • For Operation, select Compare
  • For Command, browse for C:\Program Files\Beyond Compare 2\BC2.exe
  • For Arguments, type /%1 %2
  • Click OK to accept

Do the same for Merging.

Tuesday, June 16, 2009

SQL Server 2008 Annoying warning when saving changes : Saving Changes Not Permitted

When I started working with SQL server 2008 express edition I got a new message that I have not seen in previous versions of SQL Server. The designer does not allow to save table changes like before.

This is the warning message:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
After searching at the options menu I noticed you can disable this warning by unchecking the "Prevent saving changes that require table re-creation".

Since it's a warning message there is a way to remove this simply by unchecking an option in the Tools -> Options -> Designer menu context.
Uncheck the option
"Prevent saving changes that require table re-creation"

This will take care of the issue.