How to fix Database cannot be opened because it is version 661

I recently reinstalled Windows and went to load a project within Visual Studio and got the (YSOD as seen below) error that the database could not be opened  because it is version 661 And that the server supports version 655 and earlier.

Basically the issue is that the version of SqlServer Express I had on my new machine was less than that on my old in which I was developing an application in.

So what to do?

Simple !! Update the current version of SQL Server Express on my machine to a newer version.

 Click to see Full Size

Checklist to remedy:

1) Check the current version of SQL Server installed on your machine.

2) Download and install the latest version of SQL Server Express from http://www.microsoft.com/sqlserver

3) Install and voila! All is working.

Integrating WinMerge With Visual Studio 2012 / TortoiseSVN / VisualSVN

WinMerge is a great open source utility that can be used for source control code merge and code comparison within Visual Studio 2012.

You can download WinMerge from http://winmerge.org/

Download the installer and install.

Now in order to use WinMerge as your default tool for code difference and code merge you simply need to adjust Tortoise SVN settings.

image

Firstly in Visual Studio 2010 go to “Tools –> Options”

Navigate to VisualSVN and select “Tortoise SVN Settings” as shown above.

image

Under “External Programs”, select “Diff Viewer” and set the Diff Viewer settings as above to External and select the path to your WinMergeU.exe file in your installation directory.

Repeat the process for the Merge Tool as shown below.

image

WinMerge is now your default comparsion and merge tool within Visual Studio for Source Control operations.